simple sql create table syntax error

Question

this might end in a down vote but I can´t see trees because of forest:

running this sql query:

CREATE TABLE `fontFamilies` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR NOT NULL DEFAULT 'NULL',
  `designer` INTEGER NULL,
  `firstLaunch` TIMESTAMP NULL DEFAULT NULL,
  `lastUpdate` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

I get following error in http://sqlfiddle.com/

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 'NOT NULL DEFAULT 'NULL',
  `designer` INTEGER NULL,
  `firstLaunch` TIMESTAMP NU' at line 3

What is causing this error?

@marc_s, in error there is mysql, and I can not reproduce this error on sqlfiddle — Giorgi Nakeuri
– Giorgi Nakeuri, Commented Jun 14, 2015 at 11:24

AvidLearner · Accepted Answer · 2015-06-14 11:28:24Z

4

SQLFiddle uses mysql. Try setting the size of varchar:

CREATE TABLE `fontFamilies` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR(100) NOT NULL DEFAULT 'NULL',
  `designer` INTEGER NULL,
  `firstLaunch` TIMESTAMP NULL DEFAULT NULL,
  `lastUpdate` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

You can also add insert commands to the same window:

insert into `fontFamilies` values(217,'name',217,'1992-10-10 10:10:10','1992-10-10 10:10:10')

edited Jun 14, 2015 at 11:28

answered Jun 14, 2015 at 11:17

AvidLearner

4,2235 gold badges39 silver badges52 bronze badges

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

4 Comments

Alvin Thompson Over a year ago

I didn't downvote, but I don't think you need to explicitly set the varchar length. It defaults (I think) to 255.

AvidLearner Over a year ago

@AlvinThompson you can try it in SQL Fiddle (with mysql) and see if that true

Alvin Thompson Over a year ago

I guess that's it! Is that mysql specific?

AvidLearner Over a year ago

@AlvinThompson I think so

shrestha rohit · Accepted Answer · 2015-06-14 11:33:23Z

1

You must set the size of VARCHAR .

    CREATE TABLE `fontFamilies` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR(30) NOT NULL DEFAULT 'NULL',
  `designer` INTEGER NULL,
  `firstLaunch` TIMESTAMP NULL DEFAULT NULL,
  `lastUpdate` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
  );

This will work .

answered Jun 14, 2015 at 11:33

shrestha rohit

2,9402 gold badges16 silver badges23 bronze badges

Collectives™ on Stack Overflow

simple sql create table syntax error

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related