mysql一些常用命令

1、show columns from #table_name      查看表字段情况

2、show full columns from #table_name  查看更具体的表字段情况

3、select table_name from information_schema.tables where table_schema= '#database_name' and table_type='base table'    查询库中表名

4、select table_name,table_comment from information_schema.tables where table_schema = '#database_name' and table_name ='#table_name'     查询表注释

5、ALTER TABLE #TABLE_NAME COMMENT=''; 添加表注释 

6、ALTER table table_name MODIFY `column_name` datetime DEFAULT NULL COMMENT;  添加字段注释