2025-08-27 14:16
-- 修改所有表中名为 "deleted" 的字段为 "is_deleted"
SELECT
CONCAT(
'ALTER TABLE ', TABLE_NAME,
' CHANGE COLUMN ', COLUMN_NAME, ' is_deleted bigint',
-- COLUMN_TYPE,
IF(IS_NULLABLE = 'NO', ' NOT NULL', ''),
-- IF(COLUMN_DEFAULT IS NOT NULL, CONCAT(' DEFAULT ''', COLUMN_DEFAULT, ''''), ''),
';'
) AS alter_statement
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'jeelowcode2'
AND COLUMN_NAME = 'deleted';
2025-08-27 11:16
1.统一数据库字段，，，，这个更新能提供脚本吗？navicat对比，最后还是要默认值，一个一个改
