MySQL error #1064 when creating table

Question

I know there are a bunch of questions with this subject but I haven't found my mistake here. I've just started learning SQL.

My query:

CREATE TABLE IF NOT EXISTS `data` (
  `id` int(11) NOT NULL auto_increment,
  `quizid` int(11) NOT NULL default '0',
  `result` int(3) NOT NULL default '0',
  `IP` varchar(16) NOT NULL default '',
  `ts` timestamp(14) NOT NULL,
  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) NOT NULL,
  PRIMARY KEY  (`id`)' at line 6

I know the answer must be easy to spot by the right eyes.

zerkms · Accepted Answer · 2013-12-01 04:53:44Z

4

timestamp does not accept length in CREATE TABLE clause

answered Dec 1, 2013 at 4:53

zerkms

256k73 gold badges447 silver badges551 bronze badges

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

Comments

Joke_Sense10 · Accepted Answer · 2013-12-01 04:59:13Z

3

timestamp accepts length but upto 6 precision numbers. But then you need not specify length for timestamp

answered Dec 1, 2013 at 4:59

Joke_Sense10

5,3972 gold badges20 silver badges22 bronze badges

3 Comments

zerkms Over a year ago

dev.mysql.com/doc/refman/5.5/en/create-table.html does it? It's not specified in the CREATE TABLE syntax :-S

zerkms Over a year ago

Tried with TIMESTAMP(2). It was executed as if the length wasn't specified at all

Joke_Sense10 Over a year ago

you can if you specify the default value as none but then that doesn't make much of sense..

Collectives™ on Stack Overflow

MySQL error #1064 when creating table

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related