欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

How to remove auto_increment from column in mysql_MySQL

程序员文章站 2022-05-31 09:53:43
...
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:
How to remove auto_increment from column in mysql_MySQL
Now we are going to remove auto increment from column 'No' in mysql table 'table1'. The mysql query is: