给已经存在的colume添加自增语法:
ALTER TABLE table_name CHANGE column_name column_name data_type(size) constraint_name AUTO_INCREMENT;
比如:
ALTER TABLE student CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT;
给已经存在的colume添加自增语法: ALTER TABLE table_name CHANGE column_nam…
给已经存在的colume添加自增语法:
ALTER TABLE table_name CHANGE column_name column_name data_type(size) constraint_name AUTO_INCREMENT;
比如:
ALTER TABLE student CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT;