How to remove auto_increment from column in mysql_MySQL

                         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: