Skip to content
Advertisement

Error(1064) (42000) : check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 9

My sql table is giving error but I cant find one !

This my sql table :

Error:

mysql> SOURCE /home/q55555b/Documents/Database Systems/Final Assesment_20193113/createawardprize.sql ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘–table 5

DROP TABLE IF EXISTS Awardprize’ at line 1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 9

Advertisement

Answer

https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-comments.html says:

… the -- start-comment sequence must be followed by a space…

You wrote this:

Change it to this:

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement