alter table user modify ticket varchar (12) null;
有没有数据库客户端,在客户端修改吧
https://jingyan.baidu.com/article/d5c4b52beca06b9b570dc567.html
ALTER TABLE user ALTER COLUMN "ticket" TYPE varchar(12) ;
ALTER TABLE user ALTER COLUMN ticket TYPE varchar (12) SET DEFAULT NULL;
ALTER TABLE `user` MODIFY `ticket` varchar (12) NULL;
ALTER TABLE user MODIFY ticket varchar (12) ALTER COLUMN ticket SET DEFAULT NULL;
ALTER TABLE `user` ALTER COLUMN `ticket` TYPE varchar(12) SET DEFAULT null;
表名和字段都加上反引号