MdFarzan
Reputation: 390
Auto increment a field in mysql after creation of table
How to apply a column to be auto-increment after creating the table in mysql? I have googled it, but I got only table level results.
Upvotes: 0
Views: 39
Answers (1)
MdFarzan
Reputation: 390
It's applied by altering the table. MYSQL command is: ALTER TABLE table_name MODIFY col_name INT AUTO_INCREMENT;
Upvotes: 2
Related Questions
- How do I make another MySQL auto increment column?
- SQL create table and set auto increment value without Alter table
- adding a kind of auto increment column to a mysql table
- mySQL AUTO_INCREMENT column creation
- MySQL: How to create table with auto incrementing column via script
- Mysql add auto increment column
- set auto increment initial value for mysql table
- How to add a column with auto-incremented values to a table of mySql database?
- autoincrement column in SQL database
- mysql PHP auto increment column