Howtoremoveauto_incrementfromcolumninmysql_MySQL
来源：懂视网
责编：小采
时间：2020-11-09 19:19:52
Howtoremoveauto_incrementfromcolumninmysql_MySQL
Howtoremoveauto_incrementfromcolumninmysql_MySQL:Alter table table_name DROP PRIMARY KEY, change column_name column_name datatype(length) definitionConsider the example:The structure of table1 in database new look like this: Now we are going to remove auto increment from column 'No' in m
导读Howtoremoveauto_incrementfromcolumninmysql_MySQL:Alter table table_name DROP PRIMARY KEY, change column_name column_name datatype(length) definitionConsider the example:The structure of table1 in database new look like this: Now we are going to remove auto increment from column 'No' in m
Alter table table_name DROP PRIMARY KEY, change column_name column_name datatype(length) definition
Consider the example:
The structure of table1 in database new look like this:
Now we are going to remove auto increment from column 'No' in mysql table 'table1'. The mysql query is:
Howtoremoveauto_incrementfromcolumninmysql_MySQL
Howtoremoveauto_incrementfromcolumninmysql_MySQL:Alter table table_name DROP PRIMARY KEY, change column_name column_name datatype(length) definitionConsider the example:The structure of table1 in database new look like this: Now we are going to remove auto increment from column 'No' in m
