Syntax Error MYSQL 1064

Question

I've had this error attempting to create a table that I just can't figure out. I'll try to explain it to the best of my abilities.

In the mysql command line, I'm entering

CREATE TABLE index(references INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(600), description VARCHAR(2500));

It repetitively gives me the 1064 error telling me something is wrong in the syntax that is near 'index(references INT NOT N... name VARCHAR(5600), des'.

I've tried renaming the table to random letters thinking it was possibly the name though no, any ideas anybody? I really would appreciate any help, thank you!

EDIT: My version does support VARCHAR's over 255 also. EDIT 2: Solved, renamed a couple data type names and the table name ^.^, thanks for everybody's help!

Drew · Accepted Answer · 2015-12-06 07:32:16Z

2

I know this gets through. Use back-ticks. And a typo on varchar.

CREATE TABLE `index`
(   `references` INT AUTO_INCREMENT PRIMARY KEY, 
    `name` VARCHAR(600), 
    `description` VARCHAR(2500)
);

Take a look at Mysql Reserved Words and Keywords

Special care must always be used with the names with an (R) in that link. They need back-ticks. Better yet, choose another word/name.

Edit: To answer one of your comment questions below.

create table `table2`
(
    `id` int auto_increment primary key,
    `colB` decimal(12,2) not null
);

insert table2 (colB) values (3.14),(100);

select * from table2;
+----+--------+
| id | colB   |
+----+--------+
|  1 |   3.14 |
|  2 | 100.00 |
+----+--------+

edited Dec 6, 2015 at 7:32

answered Dec 6, 2015 at 7:27

Drew

25k10 gold badges47 silver badges81 bronze badges

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

Collectives™ on Stack Overflow

Syntax Error MYSQL 1064

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related