Lishavel Lishanthini
Last answered:

19 Nov 2022

 Posted on:

17 Nov 2022
1

Error on creating a sales table

in SQL / Additional notes on using tables

image.png



Hi, I'm getting an error while adding an auto-increment keyword also in the item_code the varchar value shows an error.Help me out to sort this issue

2 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

18 Nov 2022
0

Hi Lishavel!
Thanks for reaching out.

Actually, the code is correct. Could you please share with us a screenshot from your Workbench containing the whole error message?

Looking forward to your answer.
Best,
Tsvetelin

Lishavel Lishanthini
Posted on:

19 Nov 2022
0

Hi Tsvetelin Tsonkov !



image.png
Here I have attached the error message for your reference. Kindly help me in sorting out this.

Thanks
Lishanthini  :)

Submit an answer

related questions

Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
THOMAS BELL
1
16
14. SQL JOINs - Error Code: 1055 (only_full_group_by)
Harsha Dharmabandu
1
14
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty
yenni kosasih
0
14
error code 1140 : in aggregated query without group by
Donald Trenholm
0
14
Resolved: Getting error code 1140 even after trying the fixes.
abiola Emili
0
12
Resolved: error 1055 im mysql project
Christopher Watts
1
12
Error Code: 1364. Field 'customer_id' doesn't have a default value
Joe
1
12
Resolved: S Error code 1055
lalit yadav
7
12
Resolved: M query fetch time increased after creating an index for the salaries table!
BAO QUOC NGUYEN
0
10
Resolved: Error Code: player_err_timeout
Matt Birch
0
10
Error after Error: Can't create a table this time
Snoor Salihi
0
10
Resolved: Drop table from the database