Search code examples
mysqlmysql-workbenchmysql-5.5

How to add auto-increment column in MySQL table with some particular number?


I want to add a new primary key auto-incremented column with alter command but I don't want to start it with 1.

Note: My table has data for other columns so i want to add a new-column that starts its auto increment with some number other than 1.

So is there any way to achieve this with the alter command to add column.


Solution

  • I research, do experiments and found that this is not possible to add the new column in existing data table with auto increment that starts with number another then 1.