- 拼接添加字段sql
SELECT
concat( 'ALTER TABLE ', table_schema, '.', table_name, ' ADD COLUMN gender varchar(32) NULL;' )
FROM
information_schema.TABLES t
WHERE
table_schema = 'dxmh_none';
- 执行拼接好的sql
SELECT
concat( 'ALTER TABLE ', table_schema, '.', table_name, ' ADD COLUMN gender varchar(32) NULL;' )
FROM
information_schema.TABLES t
WHERE
table_schema = 'dxmh_none';