Friday, 15 September 2017

mysql - SQL Syntax error when I execute query

I have in this query an syntax error:



$sql = "CREATE TABLE cb (
id INT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

p VARCHAR(255) NOT NULL,
t1 VARCHAR(255) NOT NULL,
t2 VARCHAR(255) NOT NULL,
type ENUM,
title VARCHAR(255) NOT NULL
)


Anyone can help me to resolve this error?




EDIT: The error is




Error creating table:
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 ' title VARCHAR(255) NOT NULL )' at line 6


No comments:

Post a Comment

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...