update tablename set s_role = '' alter table tablename modify column s_role int(11) 转载于:https://www.cnblogs.com/zhaomeizi/p/10071392.html