creating table syntax error

Question

I have a problem creating the table. It says unexpected parenthesis at line 3

CREATE DATABASE scl_teachers;

USE scl_teachers;

CREATE TABLE clteacher (
    'id' INT (10) PRIMARY KEY auto_increment,
    'f_name' VARCHAR(255) NOT NULL,
    'mid_initials' (255) IS NULL,
    'l_name' VARCHAR(255) NOT NULL,
    'saturation' VARCHAR(2)
);

score 2 · Answer 1 · answered Dec 23 '14 at 18:01

2

You don't use single quotes ' to quote identifiers in MySQL. You use a backtick ` or you can use nothing at all, if the identifier isn't a reserved word.

'mid_initials' (255) IS NULL,

Should be

`mid_initials` VARCHAR(255) DEFAULT NULL,

...although using a VARCHAR(255) seems unnecessarily large.

answered Dec 23 '14 at 18:01

Michael - sqlbot

22,595
2
47
75

solved!! Thnaks – CD_NS Dec 23 '14 at 18:18

Kris Gruttemeyer · Answer 2 · 2014-12-23T18:01:57.463

1

The datatype int doesn't accept a data length. int is just int.

So, this should get you going:

CREATE TABLE clteacher (
    `id` INTEGER AUTO_INCREMENT PRIMARY KEY
    ,f_name VARCHAR(255) NOT NULL
    ,mid_initials VARCHAR(255) NULL
    ,l_name VARCHAR(255) NOT NULL
    ,saturation VARCHAR(2)
    );

edited Dec 23 '14 at 18:01

answered Dec 23 '14 at 17:38

Kris Gruttemeyer

3,834
1
21
43

removed the length. still same error. – CD_NS Dec 23 '14 at 17:40
What you're looking for is called `IDENTITY'. You feed it a start (seed) value, then how much to increment by. I've updated my answer. – Kris Gruttemeyer Dec 23 '14 at 17:42
the error code is syntax error: unexpected '(' (opening parenthesis) – CD_NS Dec 23 '14 at 17:44
Forgot, it's mysql. Updating answer – Kris Gruttemeyer Dec 23 '14 at 17:47
doesn't help. still the same. I am working in mysql workbench 6.2. – CD_NS Dec 23 '14 at 17:51
Same exact error? – Kris Gruttemeyer Dec 23 '14 at 17:59

creating table syntax error

2 Answers2