mysql 存储过程 参数VARCHAR类型 报错 求指点 10
CREATEPROCEDUREtestvav1(inbtVARCHAR(255))BEGINselect*fromAwheretitlelikeCONCAT("'%",b...
CREATE PROCEDURE testvav1(in bt VARCHAR(255))
BEGIN
select * from A where title like CONCAT("'%",bt,"%'");
END;
报错 Error : 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 '' at line 3
Error : 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 'END' at line 1 展开
BEGIN
select * from A where title like CONCAT("'%",bt,"%'");
END;
报错 Error : 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 '' at line 3
Error : 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 'END' at line 1 展开
1个回答
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
