SQL syntax error creating table?

Question

I'm a beginner programmer in MySQL. When I'm creating a table called message in my database called chat, this is the error:

Error creating Table: 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 'from CHAR(30),to TEXT(300),text TEXT(1000),index INT(10) NOT NULL AUTO_INCREMENT' at line 1

The full MySQL statement is:

CREATE TABLE message(date DATE,from CHAR(30),to TEXT(300),text TEXT(1000),index INT(10) NOT NULL AUTO_INCREMENT,PRIMARY KEY(index))

I know the other code is correct, because I created another table previously, and it worked fine. I then copied the code and used it for this statement.

It's probably a really silly mistake, but I can't figure it out.

Please help. Thanks in advance.

Easiest to avoid using reserved words for columns/tables etc: dev.mysql.com/doc/refman/5.5/en/reserved-words.html — dcaswell
– dcaswell, Commented Sep 7, 2013 at 18:57

SeanWM · Accepted Answer · 2013-09-07 18:50:53Z

2

to, from and index are reserved words.

Try:

CREATE TABLE message(date DATE,`from` CHAR(30),`to` TEXT(300),text TEXT(1000),`index` INT(10) NOT NULL AUTO_INCREMENT,PRIMARY KEY(`index`))

answered Sep 7, 2013 at 18:50

SeanWM

17.1k10 gold badges54 silver badges85 bronze badges

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

1 Comment

ComFreek Over a year ago

You have to quote the last index occurrence, too.

Ali Akbar Azizi · Accepted Answer · 2013-09-07 18:50:14Z

1

from is a mysql reserved words,

you must add from in `,

UPDATE: to,index is key too, here the right sql

CREATE TABLE message(date DATE,`from` CHAR(30),`to` TEXT(300),text TEXT(1000),`index` INT(10) NOT NULL AUTO_INCREMENT,PRIMARY KEY(`index`))

answered Sep 7, 2013 at 18:50

Ali Akbar Azizi

3,5654 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

SQL syntax error creating table?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related