mysql - SQL 语法错误 - 第 19 行

Question

我有 MySQL 问题。什么不起作用？

#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 19

SELECT * , SUBSTRING( CONVERT( attributes
USING latin1 ) 
FROM 18 ) AS 'duplicated serials'
FROM player_items
WHERE SUBSTRING( CONVERT( attributes
USING latin1 ) 
FROM 18 ) 
IN (

SELECT SUBSTRING( CONVERT( attributes
USING latin1 ) 
FROM 18 ) 
FROM player_depotitems
WHERE CONVERT( attributes
USING latin1 ) LIKE '%serial%'
GROUP BY SUBSTRING( CONVERT( attributes
USING latin1 ) 
FROM 18 ) 
HAVING COUNT( * ) >0

感谢您的帮助。我没有更多的想法。

Answer 1

IN 没有右括号。