Mysql query giving error

Question

1.00/5 (1 vote)

See more:

C#

SELECT u.Id as UserId,u.Nikname as Nikname,u.surName,s.FormId,s.oldId,s.Mess,s.Date,s.Id as FrmId,s.pic  FROM db.user as u, db.`dbo.stud` as s WHERE u.Id IN(SELECT MId as Id  FROM db.`dbo.Common` WHERE studId='1' AND studStatus=1 UNION SELECT studId as Id FROM db.`dbo.stud` WHERE Id='1' AND studStatus=1));

I used this MySql query but it give an error.
please help me make this query error free

What I have tried:

C#

SELECT u.Id as UserId,u.Nikname as Nikname,u.surName,s.FormId,s.oldId,s.Mess,s.Date,s.Id as FrmId,s.pic  FROM db.user as u, db.`dbo.stud` as s WHERE u.Id IN(SELECT MId as Id  FROM db.`dbo.Common` WHERE studId='1' AND studStatus=1 UNION SELECT studId as Id FROM db.`dbo.stud` WHERE Id='1' AND studStatus=1));

I used this MySql query but it give an error.
please any me make this query error free

Posted 20-Apr-16 5:03am

Kishor-KW

Updated 20-Apr-16 5:25am

v2

Add a Solution

Comments

CHill60 20-Apr-16 11:04am

Do you want to give us a clue what the error was?

Kishor-KW 20-Apr-16 11:07am

Error Code: 1064. 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 '' at line 1

in mysql wrokbench 5.5

CHill60 20-Apr-16 11:12am

It could be the characters you are using to surround your table names - try changing them to a simple single-quote mark '.
If that doesn't work then try running each of the sub-queries separately to see which area of the query is at fault

Kishor-KW 20-Apr-16 11:15am

both query working well individually query at start and queries in ( )

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2016-04-20T05:25:00

The problem is here

SQL

AND studStatus=1));

There should only be one closing bracket

SQL

AND studStatus=1);

Whitespace can be your friend ... I pasted your query into SQLFiddle and inserted some linefeeds ...

SQL

SELECT u.Id as UserId,u.Nikname as Nikname,u.surName,
s.FormId,s.oldId,s.Mess,s.Date,s.Id as FrmId,s.pic  
FROM user as u, `stud` as s 
WHERE u.Id IN (
  SELECT MId as Id  FROM `Common` 
  WHERE studId='1' AND studStatus=1 
  UNION 
  SELECT studId as Id FROM `stud` WHERE Id='1' AND studStatus=1)
  );

The error message then said the error was on Line 9 ... straight to the problem!