mysql查看表名及注释的方法:执行【select table_name from information_schema.tables where table_schema='数据库名称';】语句即可查看。查询所有表名(推荐教程:mysql视频教程)1select table_name from information_schema.tables where table_schema='数据库名称';查询数据库表名的注释:1select table_name 表名,TABLE_COMMENT 表注释 fr
mysql注释是中文乱码的解决办法:首先用“show variables like”命令查看数据库与服务端的字符集设置;然后执行语句为“set collation_server=utf8_general_ci;”即可。推荐:《mysql视频教程》mysql表注释乱码问题执行语句: alter table TABLE_XXX comment ‘中文号’;结果: use information_schema;12select * from TABLES where TABLE_SCHEMA=’mydb’ an