给MySQL批量增加时间戳
SELECT CONCAT('alter table ',A.TABLE_NAME,' add BUF_UPDATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP;') FROM INFORMATION_SCHEMA.TABLES A where table_schema='DBNAME';
给MySQL批量增加时间戳
SELECT CONCAT('alter table ',A.TABLE_NAME,' add BUF_UPDATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP;') FROM INFORMATION_SCHEMA.TABLES A where table_schema='DBNAME';