Mysql查询给出错误 [英] Mysql query giving error

问题描述

 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 < span class =code-keyword> 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!

这篇关于Mysql查询给出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！