mysql 变量报错 (error encountered during command execution)

项目中sql(select (@rownumber := @rownumber + 1) RowNumber)在本地 正常,但是发布到服务器就一直提示:"error encountered during command execution",原因是mysql不支持自定义参数,解决方案,配置文件中增加:Allow User Variables=True

posted @ 2015-12-15 00:57  了了_  阅读(499)  评论(0编辑  收藏  举报