添加列(在cellphone列后添加email列)
ALTER TABLE classmates ADD email VARCHAR( 30 ) NOT NULL AFTER cellphone
修改原有列email
ALTER TABLE classmates MODIFY email VARCHAR(30) NOT NULL
添加列(在cellphone列后添加email列)
ALTER TABLE classmates ADD email VARCHAR( 30 ) NOT NULL AFTER cellphone
修改原有列email
ALTER TABLE classmates MODIFY email VARCHAR(30) NOT NULL