Yang

Appearance

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';