How can I add an AUTO_INCREMENT to an already existing table?

in SQL / UNIQUE Constraint

Have tried altring the table and adding auto_increment(customer_id) but giving error.

1 answers ( 0 marked as helpful)

Ivan Manov

Instructor

Posted on:

11 Apr 2024

Hi Namnso!

Thanks for reaching out!

Can you please provide a screenshot of the error you're encountering?

Please note that to add an AUTO_INCREMENT attribute to a column, the column must be defined as a key. So, if that's not specified, you'll get an error.

Best,

Ivan

Submit an answer

related questions

Islam Elkhateeb

Resolved: can't add row, I do may trail and it all back with errors

Alessandro Imbrìaco

Resolved: Can't understand what LEFT JOIN does

Sivarajan Sivakumar

Cannot insert 999903 into the dept_emp table?

Marcus Wern Han Leong

Why did you not do not null, primary key and auto increment for customer id in the solution?

Harsha Dharmabandu

Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty

lalit yadav

Resolved: M query fetch time increased after creating an index for the salaries table!

Matt Birch

Error after Error: Can't create a table this time

Edu Jr Haban

how can you apply primary keys in multiple columns