Syntax error in SQL create table

Question

Hi I am trying to get more familiat with SQL and I am using MySql to test my SQL queries.I seem to be getting a sintax error in this statement:

CREATE TABLE dog
(
  id int(11) NOT NULL auto_increment,
  name varchar(255),
  descr text,
  size enum('small','medium','large'),
  date timestamp(14),
  PRIMARY KEY (id)
)ENGINE = InnoDB;

Error:

#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 '(14), PRIMARY KEY (id) )ENGINE = InnoDB' at line 7

What am I doing wrong here?

Remove (11) from your query just use id int NOT NULL auto_increment, — 4b0
– 4b0, Commented Oct 18, 2012 at 9:58
I hope it should be an warning in statement it not an error:) — thar45
– thar45, Commented Oct 18, 2012 at 10:03

thar45 · Accepted Answer · 2012-10-18 10:06:09Z

4

try mentioning like this

CREATE TABLE dog

(
  id int NOT NULL auto_increment,
  name varchar(255),
  descr text,
  size enum('small','medium','large'),
  date timestamp,
  PRIMARY KEY (id)
)
ENGINE = InnoDB;

edited Oct 18, 2012 at 10:06

thar45

3,5705 gold badges35 silver badges49 bronze badges

answered Oct 18, 2012 at 10:04

Saasu Ganesan

1808 bronze badges

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

Comments

Bhavik Shah · Accepted Answer · 2012-10-18 10:00:05Z

2

'TIMESTAMP(14)' is deprecated; use 'TIMESTAMP' instead

answered Oct 18, 2012 at 10:00

Bhavik Shah

5,1933 gold badges26 silver badges40 bronze badges

Comments

VeZoul · Accepted Answer · 2012-10-18 10:08:11Z

1

Try this :

CREATE TABLE dog

(
  id int NOT NULL auto_increment PRIMARY KEY,
  name varchar(255),
  descr text,
  size enum('small','medium','large'),
  date timestamp
)
ENGINE = InnoDB;

PRIMARY KEY statement has to be precised with the field declaration

answered Oct 18, 2012 at 10:08

VeZoul

5206 silver badges19 bronze badges

Collectives™ on Stack Overflow

Syntax error in SQL create table

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related