我的语句如下:
CREATE PROCEDURE showdb( v_offset int, v_pagesize int )
SELECT * FROM 'comment' ORDER BY id DESC LIMIT v_offset , v_pagesize;但是提示:
Error Code : 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 ''comment' ORDER BY id DESC LIMIT v_offset , v_pagesize' at line
(0 ms taken)请问是什么问题呢?
谢谢!
CREATE PROCEDURE showdb( v_offset int, v_pagesize int )
SELECT * FROM 'comment' ORDER BY id DESC LIMIT v_offset , v_pagesize;但是提示:
Error Code : 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 ''comment' ORDER BY id DESC LIMIT v_offset , v_pagesize' at line
(0 ms taken)请问是什么问题呢?
谢谢!
解决方案 »
- 为什么我的mysql显示会异常呢
- mysql中复制表数据提示报错
- mysql怎么定时更新?
- 数据字典information_schema.TABLES里面的TABLE_ROWS不正确
- 按照已有的主键来分表是否有意义呢?
- 请高手指教:Can not issue data manipulation statement with executeQuery().我用的是MySQL4.1,mysql-connector-java-3.1.14,Tomcat5.0
- MYSQL编程问题
- SQL数据库分页算法?
- 求助,如何做数据匹配?
- mysql用a表数据更新b表
- 如何把Mysql数据库和应用程序打包
- mysql 分区
DELIMITER ||
CREATE PROCEDURE showdb( v_offset int, v_pagesize int )
BEGIN
SET @stmt = concat("SELECT * FROM `comment` ORDER BY id DESC LIMIT ",v_offset,",",v_pagesize);
PREPARE s1 FROM @stmt;
EXECUTE s1;
DEALLOCATE PREPARE s1;
END||
DELIMITER ;(0 row(s)affected)
(0 ms taken)