CODEWITHSUNDEEP
mysqlsyntax
MewX86
MewX86

Reputation: 11

SQL : Syntax ERROR 1064 (42000): can't identify the issue?

Client table that i want to Create

I typed this code :

TABLE Client CODE

When i execute the command i got the message below :

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 ') ENGINE=InnoDB' at line 6

Could you please help to solve this issue?

Upvotes: 0

Views: 87

Answers (1)

iamsankalp89
iamsankalp89

Reputation: 4739

Just remove , after email in the table creation

CREATE TABLE Client 
(numero int unsigned primary key AUTO_INCREMENT, 
nom varchar(40) NOT NULL,
prenom varchar(40) NOT NULL,
email varchar(40) NOT NULL)
ENGINE =InnoDB;

Upvotes: 2

Related Questions