create table test(
id int PRIMARY key, text VARCHAR(2048) ) ALTER TABLE test ADD(create_time date);ALTER TABLE test MODIFY CREATE_time TIMESTAMP;
alter TABLE test ADD(time TIMESTAMP)
alter table test CHANGE column CREATE_time create_time TIMESTAMP
alter table test drop COLUMN time