Mysql查询给出错误

本文介绍了Mysql查询给出错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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 ））;

我使用了这个MySql查询，但是它给出了一个错误。 请帮我这个查询没有错误 我尝试了什么：

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 ））;

我使用了这个MySql查询但是它给出错误。 请任何我这个查询没有错误

解决方案

问题在这里

AND studStatus = 1））;

应该只有一个结束括号

AND studStatus = 1）;

空格可以是你的朋友......我将你的查询粘贴到SQLFiddle并插入一些换行符...

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 ` ` WHERE studId = ' 1' AND studStatus = 1 UNION SELECT studId as Id FROM `stud` WHERE Id = ' 1' AND studStatus = 1））;

错误信息然后表示错误在第9行...直接问题！

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:

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

解决方案

The problem is here

AND studStatus=1));

There should only be one closing bracket

AND studStatus=1);

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

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!