MySQL syntax error in subquery

Question

What's wrong with this MySQL query?

    $result = mysql_query("SELECT did FROM publications where group IN 
(SELECT s_group FROM subscriptions where uid1='$id')") or die(mysql_error());

I am getting syntax error:

        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 's_group FROM 
subscriptions where uid1='34846')' at line 1

possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — Ian Ringrose
– Ian Ringrose, Commented May 6, 2014 at 10:13

Jim · Accepted Answer · 2014-01-10 10:43:57Z

3

GROUP is a reserved keyword. Surrounding with ` will signify it's a column name:

SELECT did FROM publications where `group` IN 
(SELECT s_group FROM subscriptions where uid1=1)

answered Jan 10, 2014 at 10:43

Jim

22.7k6 gold badges55 silver badges81 bronze badges

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

2 Comments

AmazingDreams Over a year ago

Best practice I think is to always use them.

eggyal Over a year ago

But the parser did not balk at group... it had an issue at s_group ? Suggests the OP has either not posted his exact query, or his exact error message. Beware.

paulius marko · Accepted Answer · 2014-01-10 10:44:43Z

1

you have to write "group" column like group, because keyword group is reserved keyword in MySQL.

$result = mysql_query("SELECT did FROM publications where `group` IN 
(SELECT s_group FROM subscriptions where uid1='$id')") or die(mysql_error());

Or you can user alias

$result = mysql_query("SELECT did FROM publications p where p.group IN 
(SELECT s_group FROM subscriptions where uid1='$id')") or die(mysql_error());

answered Jan 10, 2014 at 10:44

paulius marko

152 bronze badges

Comments

Pradeep Sharma · Accepted Answer · 2014-01-10 10:51:06Z

0

follow what @paulius said and then check data type of uid1 if it's number than remove quotes from $id

answered Jan 10, 2014 at 10:51

Pradeep Sharma

3274 silver badges15 bronze badges

2 Comments

Cris Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.

Pradeep Sharma Over a year ago

I can't comment on an author's post that is why I answered here and now I can comment here.

Collectives™ on Stack Overflow

MySQL syntax error in subquery

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related