如果是存储过程,可以试试动态SQL
set @sql_1 = " select * from .......limit ? "
prepare stmt from @sql_1
execute stmt using @step
deallocate prepare stmt
commit
select * from film1 where (select num from mark where id= (select max(id) from mark ) )=1union
select * from film2 where (select num from mark where id= (select max(id) from mark ) )=2
对MYSQL语法不熟悉,不知道这样可以不
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)