I didn't set auto-increment when creating a mysql data table. how can I set auto-increment later? Use the command or phpmydamin ------ solution ------------------ command: altertablettmodifyidintauto_incrementprimarykeyphpmyadmin also has related functions. ------ Solution ------------------- when creating a mysql data table, auto-increment is not set. how can I set auto-increment later?
Use command or phpmydamin
------ Solution --------------------
Command: alter table tt modify id int auto_increment primary key
Phpmyadmin also provides related functions.
------ Solution --------------------
Go to phpmyadmin to view the table structure. if you modify a field, check auto_increment.
------ Solution --------------------
SQL tools are used in this era: http://download.csdn.net/detail/dmtnewtons/4230136
Graphic interface, good operation