Izzatilla Rakhmatullaev
Last answered:

25 Oct 2023

 Posted on:

12 Oct 2023
0

Resolved: Cannot add auto increment

in SQL / NOT NULL Constraint - Part I

2 answers ( 1 marked as helpful)
Tanika
Posted on:

12 Oct 2023
0

Auto_increment can be set on an INT column.

The company_id column that you are trying to set auto increment on is varchar(255). 

Helpful answer
Tsvetelin Tsonkov
Instructor
Posted on:

25 Oct 2023
0

Hi Izzatilla!
Thanks for reaching out.


As Tanika explained, please set the company_id column to INT.


Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Islam Elkhateeb
3
26
Resolved: can't add row, I do may trail and it all back with errors
Sivarajan Sivakumar
0
16
Cannot insert 999903 into the dept_emp table?
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Hasan Arda Burhan
3
8
When will you add English subtitles?
Izzatilla Rakhmatullaev
0
6
Resolved: Cannot change column with default
Gilliane Pornasdoro
0
6
How to add value on previous row
Mohamed AbdulHalim
0
4
Why did we add MIN in this query?
Houda
2
4
why you add a not null in the sales table besides primary key