Remove auto_increment from column in mysql

                       You created a table in which the column with specific definitions in mysql. You created table column with auto increment. To add auto increment to existing column, visit  add-auto-increment-to-existing-column in mysql. Then how can you remove it from column in mysql.  The following mysql query is used to remove auto increment from column in mysql.

Mysql Query:

                         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:

                     Alter table table1 DROP PRIMARY KEY,
                      change No No int(5) NOT NULL

Now your structure look like this:

 
               Now you can see the column name 'No' is normal. There is no auto increment.

Related Post:

Change column name in mysql
Change column size in mysql table
Delete column in mysql table
Add column after specific field in mysql table
Move columns in mysql table

change column datatype in mysql
Change table name in mysql
Add primary key to existing column in mysql
how to add auto increment to existing column in mysql
How to reset auto increment initial value in mysql
How to use order by before group by in mysql
Select distinct values in mysql