Home > Database > Mysql Tutorial > How to remove auto_increment from column in mysql_MySQL

How to remove auto_increment from column in mysql_MySQL

WBOY
Release: 2016-06-01 13:13:03
Original
963 people have browsed it

                         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:

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template