我想创建多语句的存储过程,但它不工作,谷歌这个问题,并发现mysql不支持Subquery语句"MySQL还不支持'LIMIT &IN/ALL/ANY/SOUN子查询‘“DROP PROCEDURE`proc_Name`() SELECT FROM table1 WHERE ORDER BY table1_Colom LIMIT 100;
UPDATE table2 SETtable2
update share set holder = 22 where SHARE_ID IN (select SHARE_ID from SHARE WHERE holder=1 LIMIT 10)#1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
DELETE FROM tests WHERE EXISTS (SELECT * FROM tests WHERE user_id = 38 ORDER BY test_timestamp DESC LIMIT20, 100);DELETE FROM tests WHERE user_id = 38 ORDER BY test_timestamp DESC LIMIT 20, 100;
是否有任何更改可以使上述任何一个示例工作
, category WHERE book.category=category.id AND book.id IN (SELECT book.id FROM book ORDER BY rating LIMIT3) #1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
解决方案说需要最少的MySQL 5.1,我
此MySQL-Query:WHERE t_1.title_search IN SELECT title_search FROM t_2 limitThis version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
通过谷歌搜索,我在MySQL的上找到了mysqlf我知道,这种形式的查询是<em
如何通过这个查询实现我想要的:(SELECT id FROM posts order by timestamp desc limitMySQL还不支持“限制”& IN/ALL/ANY/SOME子查询
mySQL Server version: 5.5.8
mySQL Client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625