Smriti
Last answered:

04 Feb 2022

 Posted on:

05 Jan 2022
0

Not able to create a table

in SQL / Welcome to SQL

image.png



Hi

I dropped a table. And I  was trying to create it again.L is giving an error. Please help me resolve it.

Regards
Smriti

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

04 Feb 2022
0

Hi Smriti!

Please, remove the comma(,) on Line 27. We separate columns with commas, but we do not use a comma after the last one. This is a syntax error according to the official MySQL documentation and this is why an error 1064 occurs.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Rhys Morgan
3
28
Rollback not reverting DB state after using INSERT INTO
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
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
Joseph Skvarna
1
14
Resolved: employees.sql database not found in resources
Sivarajan Sivakumar
0
14
Cannot insert 999903 into the dept_emp table?
Lizeth Alexandra Estevez Joya
0
12
The schema section does not show the tables in the Tables subsection.
Bader Alsahli
3
12
sample employee Database not found as resource to be downloaded
Anna Znosko
0
12
Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly