SELECT * FROM tablename; | |
ALTER TABLE tablename RENAME COLUMN CONDITION TO condition_backup; -- 修改列名 | |
ALTER TABLE tablename ADD condition clob NULL; -- 新增列 | |
UPDATE tablename set condition=condition_backup; -- 数据 copy 到新列,注意 commit | |
ALTER TABLE tablename DROP COLUMN CONDITION_BACKUP; -- 删除旧列 | |
SELECT * FROM tablename; |