Gaea icon indicating copy to clipboard operation
Gaea copied to clipboard

Published 20 hours ago • verified publisher icon XiaoMi

prepare类型语句出错

Open smilethensee opened this issue 2 years ago • 3 comments

用mysql官网的prepare语句测试 PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse'; SET @a = 3; SET @b = 4; EXECUTE stmt1 USING @a, @b; 报错如下: ERROR 1243 (HY000): Unknown prepared statement handler (stmt1) given to EXECUTE

smilethensee avatar Jun 23 '22 08:06 smilethensee

Gaea支持二进制Prepare协议, 但对文本Prepare没有明确支持

teckick avatar Jun 23 '22 08:06 teckick

Gaea支持二进制Prepare协议, 但对文本Prepare没有明确支持

那我该怎么写prepare语句呢？不是很懂。要通过jdbc这种工具吗？

smilethensee avatar Jun 23 '22 11:06 smilethensee

Gaea支持二进制Prepare协议, 但对文本Prepare没有明确支持

那我该怎么写prepare语句呢？不是很懂。要通过jdbc这种工具吗？

是的. https://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html

teckick avatar Jun 24 '22 02:06 teckick