添加整库不存在的字段
提示:查询一个表存在该字段
SELECT DISTINCT TABLE_NAME FROM information_schema.COLUMNS WHERE COLUMN_NAME = 'xxx' AND TABLE_SCHEMA = '库'
查询整库不存在并拼接成添加sql语句
提示:在创作的过程中都有哪些收获
SELECT CONCAT( "ALTER TABLE ", table_name, " ADD xxx varchar(64) NOT NULL default '' COMMENT 'id';" ) FROM information_schema.TABLES WHERE table_schema = '库' AND TABLE_NAME NOT IN ( SELECT DISTINCT TABLE_NAME FROM information_schema.COLUMNS WHERE COLUMN_NAME = 'xxx' AND TABLE_SCHEMA = '库' )
;