SQL Syntax error when I execute query

Question

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

what was then error?

Madhivanan
– Madhivanan

2015-06-25 10:10:54 +00:00
Commented Jun 25, 2015 at 10:10 — Madhivanan
– Madhivanan, Commented Jun 25, 2015 at 10:10
Try sth like type ENUM ('a', 'b', 'c'),...

Giorgos Betsos
– Giorgos Betsos

2015-06-25 10:11:51 +00:00
Commented Jun 25, 2015 at 10:11 — Giorgos Betsos
– Giorgos Betsos, Commented Jun 25, 2015 at 10:11

Abhik Chakraborty · Accepted Answer · 2015-06-25 10:12:00Z

3

ENUM needs enumeration values to be supplied as string literals something as

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('1','2'),
title VARCHAR(255) NOT NULL
)

https://dev.mysql.com/doc/refman/5.0/en/enum.html

answered Jun 25, 2015 at 10:12

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Syntax error when I execute query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related