用动态执行SQL语句的方法
PREPARE stmt1 FROM 'select * from users LIMIT ?,?';
SET @a = ino;
SET @b = pagecount
EXECUTE stmt1 USING @a, @b;
deallocate prepare stmt1;
or
set dd=conact('select * from users LIMIT',ino,pagecount)
PREPARE stmt1 FROM dd
EXECUTE stmt1
deallocate prepare stmt1;
阅读(2228) | 评论(0) | 转发(0) |
