怎么将下面的sql语句从mssqlserver2k转到mysql?
说明:
下面的语句是用来找出表debug_tasks 里未用的最小的task_id 号,我近日将数据库从
mssqlserver2k转为mysql,却碰到这条语句无法通过,
请教各位高手,
类似这样的功能,我该怎么处理或实现?我对mysql 不是那么熟悉,
SELECT (CASE WHEN EXISTS(SELECT * FROM debug_tasks AS b WHERE task_id = 1) THEN task_id + 1 ELSE 1 END) AS task_id FROM debug_tasks WHERE NOT task_id IN(SELECT task_id - 1 FROM debug_tasks AS a)