Skip to content
Advertisement

This script won’t run on PHPmyadmin. Neither will any others [closed]

When trying to run this script or any script on PHPmyadmin, it shows the same error, can anyone help?

My Error :

MySQL said: Documentation

#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 Customers ( Customer_Email varchar(50) NOT NULL, Customer_Firstna’ at line 3

Advertisement

Answer

CREATE DATABASE IF NOT EXISTS Project is missing the final semicolon.
It should be CREATE DATABASE IF NOT EXISTS Project;

Naturally the error returned is on the next line because the syntax, at that point, becomes wrong.
In general when you receive an error about SQL syntax, not only check given rows but even the ones before.

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