首页 >数据库 >mysql教程 >How to remove auto_increment from column in mysql_MySQL

How to remove auto_increment from column in mysql_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原创
2016-06-01 13:13:03990浏览

                         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:
remove auto increment from column in mysql using alter, drop and change mysql command                        
                       Now we are going to remove auto increment from column 'No' in mysql table 'table1'.  The mysql query is:

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn