问题模块 框架类型 问题类型 操作时间 AppID
管理后台 微信小程序 需求 05-18 wx45e4c007679e4312
- 需求的场景描述(希望解决的问题)
在phpMyAdmin mysql 中写:
declare temp_cur cursor for select f_user_id from table_test where f_user_id=1;
报错:
错误
静态分析:
分析时发现1个错误。
Unrecognized statement type. (near "declare" at position 0)
SQL 查询: 文档
declare temp_cur cursor for select f_user_id from table_test where f_user_id=1
MySQL 返回: 文档
#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 'declare temp_cur cursor for select f_user_id from table_test where f_user_id=1' at line 1
- 希望提供的能力
请问 这怎么解决?
微信小程序开发问题解答
微信小程序开发者回答:
https://dev.mysql.com/doc/refman/8.0/en/declare.html
DECLARE is permitted only inside a BEGIN ... END compound statement and must be at its start, before any other statements.是否没有BEGIN和END?
本文网址:http://www.91bianli.com/weixinxiaochengxu/43872.html