JeremyRenner2
Reputation: 61
Modifying a primary key to auto-increment from a set value
I have the following MYSQL statement:
ALTER TABLE students MODIFY studentID INTEGER NOT NULL AUTO_INCREMENT = 20;
StudentID already exists and is primary key. I want to edit it to autoincrement from 20. However, I am getting a red line on the equals sign in mySQL Workbench and the message
= is not valid in this position, expecting EOF.
What am I doing wrong?
Upvotes: 0
Views: 572
Answers (1)
Related Questions
- automatically insert auto increment primary key and values into existing table
- Adding auto increment column other than primary key
- Add auto_increment feature to a primary key
- make an ID in a mysql table auto_increment (after the fact)
- Auto Incrementing primary key
- Adding primary key plus Auto Increment to existing column
- add primarykey with autoincrement in mysql
- Is there a way to set the primary key of an auto incremented column
- How to change a primary key in SQL to auto_increment?
- Add auto_increment to primary key in SQL