Error Code: 1064 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 'CREATE table datenbank (chemin varchar, formules varchar, da' at line 1

[christian Déprez]

Hello everyone!

I am not experienced, but I wrote a code line in sql to make a table in my database "datenbank", and I have the error code 1064 error: Could you tell me what is wrong? (I tried to pu a space after the "(" before the ")", before ";" ... and it didn't work neither ...)

Thank you for your help!

CREATE TABLE datenbank (chemin VARCHAR, formules VARCHAR, date_pleniere DATE, ID_Formule VARCHAR, ID_Avis VARCHAR, Lien VARCHAR, Observation_1 VARCHAR, Observation_2 VARCHAR, Observation_3 VARCHAR, citation_formule VARCHAR, citation_avis VARCHAR, Mot_clef_1 VARCHAR, Mot_clef_2 VARCHAR, Mot_clef_3 VARCHAR, Mot_clef_4 VARCHAR, Mot_clef_5 VARCHAR, Mot_clef_6 VARCHAR, Mot_clef_7 VARCHAR, Mot_clef_8 VARCHAR, Mot_clef_9 VARCHAR, Mot_clef_10 VARCHAR, Mot_clef_11 VARCHAR, Mot_clef_12 VARCHAR, Mot_clef_13 VARCHAR, Mot_clef_14 VARCHAR);

Christian Déprez