lahand的博客

http://www.cnblogs.com/zzwlovegfj/archive/2012/07/04/2576989.html

1.查看所有表名 show tables 2.统计表的个数 SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA=’数据库名’;

1.查询所有表SELECT CONCAT('ALTER table ',t2.table_schema,'.',t2.table_name,' CHANGE ',' \`',t2.column_name,'\` \`',UPPER(t2.column_name),'\` ',  t2.column_type,' ',CASE WHEN t2.is_nullable='NO' THEN

http://blog.youkuaiyun.com/hfmbook/article/details/41985853