/*修改原字段名name为name_tmp*/
alter table zfs_room_allot rename column roomCode to roomCode_tmp;
alter table zfs_room_allot rename column roomName to roomName_tmp;
/*增加一个和原字段名同名的字段name*/
alter table zfs_room_allot add roomCode CLOB;
alter table zfs_room_allot add roomName CLOB;
/*将原字段name_tmp数据更新到增加的字段name*/
update zfs_room_allot set roomCode=trim(roomCode_tmp);
update zfs_room_allot set roomName=trim(roomName_tmp);
/*更新完,删除原字段name_tmp*/
alter table zfs_room_allot drop column roomCode_tmp;
alter table zfs_room_allot drop column roomName_tmp;