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;