mySQL create table

Question

After reading the tutorials and examples on creating tables, I'm trying to create my own. But, the error this code gives me doesn't tell me what is wrong.

Can someone help?

CREATE TABLE feedback
(id INT NOT NULL AUTO_INCREMENT CREATE PRIMARY KEY,
email VARCHAR(80),
brand VARCHAR(30),
model VARCHAR(30),
desc VARCHAR(255),
date TIMESTAMP(8));

um, could you provide that error? It may not help you, but it probably will help us. — eykanal
– eykanal, Commented Apr 13, 2011 at 15:07

eykanal · Accepted Answer · 2011-04-13 15:08:30Z

4

You're doing the primary key declaration wrong, I believe. Leave off the word "create" and it should work.

answered Apr 13, 2011 at 15:08

eykanal

27.2k19 gold badges86 silver badges114 bronze badges

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

1 Comment

Charlie Over a year ago

That did it! Thank you! I think the "desc" column name was a problem as well (Thanks nr4bt). Thanks for the help!

Nathua · Accepted Answer · 2011-04-13 15:08:13Z

2

desc VARCHAR(255),

"desc" is a reserved keyword, It might the problem, use something else and try

Hope it helps

answered Apr 13, 2011 at 15:08

Nathua

8,8345 gold badges35 silver badges42 bronze badges

4 Comments

Charlie Over a year ago

There were two problems, as it turns out. That was one of them! Thank you! I got it working!

kapa Over a year ago

While desc is reserved, you can still use it if you write it like: `desc`

user330315 Over a year ago

@bazmegakapa: but it's not a good idea to use reserved words. Even though quoting is working, it is more hassle than it's worth

kapa Over a year ago

@a_horse_with_no_name Yes, I agree. Still good to know it is possible.

Marco · Accepted Answer · 2011-04-13 15:13:29Z

0

CREATE TABLE  `feedback` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`email` VARCHAR(80),
`brand` VARCHAR(30),
`model` VARCHAR(30),
`descr` VARCHAR(255),
`date` TIMESTAMP
)

edited Apr 13, 2011 at 15:13

answered Apr 13, 2011 at 15:08

Marco

57.7k15 gold badges135 silver badges159 bronze badges

1 Comment

Charlie Over a year ago

Yeah. I just fixed that. Sorry. That was a typo. It still doesn't work though.

OShadmon · Accepted Answer · 2016-01-19 22:04:38Z

0

I usually put my keys at the end of the create. That way if I have many keys, it's easier to follow.

CREATE TABLE  `feedback` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `email` VARCHAR(80),
  `brand` VARCHAR(30),
  `model` VARCHAR(30),
  `descr` VARCHAR(255),
  `date` TIMESTAMP,
  PRIMARY KEY (`id`)
);

answered Jan 19, 2016 at 22:04

OShadmon

7445 silver badges11 bronze badges

Collectives™ on Stack Overflow

mySQL create table

4 Answers 4

1 Comment

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related