1064 syntax error in mysql

Question

I am confused. I don't know what is the error. On execution I got a message:

" 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 'group(creator,type,name,details,icon)values (6,'information sharing','test','j' at line 1"

my query is :

INSERT INTO group 
    (creator, type, name, details, icon) VALUES
    (6, 'information sharing', 'test', 'just for testing',
    'My friend/group_uploads/pic00_6_0d46839f6371fb84f6b6c682f5fc2c77.jpeg')

this my table specification:

type      varchar(1000)
name      varchar(1000)
details   varchar(1000)
creator   bigint(20)
icon      varchar(1000)

please help me to correct the error .

just change table name "grou" to "grp" and try this query in PHP "INSERT INTO grp (type, name, details, creator, icon) VALUES ('6', 'information sharing', 'test', '0', 'My friend/group_uploads/pic00_6_0d46839f6371fb84f6b6c682f5fc2c77.jpeg');" @Shankar Damodaran is right group makes problem because of reserved word — Tirthrajsinh Parmar
– Tirthrajsinh Parmar, Commented Apr 7, 2014 at 9:33

Tirthrajsinh Parmar · Accepted Answer · 2014-04-07 09:28:19Z

3

group is a reserved word in MySQL. You need to surround it in backticks.

Like this..

insert into `group`(creator, type, name, details, icon) values ('6','information sharing','test','just for testing','My friend/group_uploads/pic00_6_0d46839f6371fb84f6b6c682f5fc2c77.jpeg')
            ^     ^

Try to avoid having such names for your columns and tables.

edited Apr 7, 2014 at 9:28

Tirthrajsinh Parmar

1681 silver badge7 bronze badges

answered Apr 7, 2014 at 9:15

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

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

Comments

Sathish D · Accepted Answer · 2014-04-07 09:42:12Z

0

Grou is Keywords in MySQL. So use backticks for those.

Try:

 INSERT INTO `group` 
        (`creator`, `type`, `name`, `details`, `icon`) VALUES
        (6, 'information sharing', 'test', 'just for testing',
        'My friend/group_uploads/pic00_6_0d46839f6371fb84f6b6c682f5fc2c77.jpeg')

edited Apr 7, 2014 at 9:42

answered Apr 7, 2014 at 9:25

Sathish D

5,04433 silver badges46 bronze badges

Comments

Rajesh · Accepted Answer · 2014-04-07 09:46:09Z

0

Even though by using backticks you can use keywords as table name , It is not recommended to use reserved word as table name

DO NOT DO IT.

Official list of reserved keywords: Reserved Keywords (Transact-SQL)

answered Apr 7, 2014 at 9:46

Rajesh

7966 silver badges12 bronze badges

Collectives™ on Stack Overflow

1064 syntax error in mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related