批量生成表修改语句

SELECT
    CONCAT("ALTER TABLE ", TABLE_NAME,
           " modify deleted tinyint(1) default false not null comment '删除标记';")
        AS target_tables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="hrms"
  AND TABLE_TYPE="BASE TABLE";

---