SELECT CONCAT(‘ALTER TABLE ’
, ‘表名’
, ’ CHANGE COLUMN ’
, COLUMN_NAME, ’ ’
, LOWER(COLUMN_NAME)
, ’ ’
, COLUMN_TYPE
, ’ COMMENT ‘’’
, COLUMN_COMMENT
, ‘’‘;’) AS ‘修改脚本’
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = ‘库名’
AND TABLE_NAME = ‘表名’;
Mysql将表字段全部改为小写
最新推荐文章于 2024-06-02 14:54:06 发布