1 创建一个临时表
create table `users` AS SELECT * FROM `user`;
2 删除原表中的数据
delete from user;
3 修改数据类型
ALTER TABLE user MODIFY id VARCHAR(255);
4 将临时表中的数据重新插入原表中
INSERT INTO user SELECT * FROM users;
5 删除临时表
DROP TABLE users;
6 提交
COMMIT
create table `users` AS SELECT * FROM `user`;
delete from user;
ALTER TABLE user MODIFY id VARCHAR(255);
INSERT INTO user SELECT * FROM users;
DROP TABLE users;
COMMIT