首頁 >資料庫 >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:03992瀏覽

                         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