My SQL

批量操作

需要批量修改所有表, 使用

sql

SELECTW
    CONCAT('ALTER TABLE ', table_schema, '.', table_name, ' ADD COLUMN `cTime` bigint NOT NULL,ADD COLUMN `uTime` bigint NOT NULL AFTER `cTime`,ADD COLUMN `dTime` bigint NULL AFTER `uTime`;')
FROM information_schema.`TABLES` t
WHERE
    table_schema = 'yang';

SELECTW
    CONCAT('ALTER TABLE ', table_schema, '.', table_name, ' ADD COLUMN `cTime` bigint NOT NULL,ADD COLUMN `uTime` bigint NOT NULL AFTER `cTime`,ADD COLUMN `dTime` bigint NULL AFTER `uTime`;')
FROM information_schema.`TABLES` t
WHERE
    table_schema = 'yang';