mysql存储过程参数很多_MySQL存储过程接受带有多个参数的字符串

最新推荐文章于 2023-11-09 10:21:51 发布

凡斯

最新推荐文章于 2023-11-09 10:21:51 发布

阅读量453

点赞数

文章标签： mysql存储过程参数很多

本文链接：https://blog.csdn.net/weixin_42355411/article/details/113237699

版权

我想创建一个存储过程,它接受IN参数中的所有值作为单个字符串.

DELETE FROM object

WHERE Type NOT IN

('ListGrid',

'TextField',

'SpinBox',

'MenuButton',

'ListGrid',

'RadioButton',

'DropDown',

'PopUp',

'Element',

'Checkbox',

'TreeDropDown',

'TblColumn',

'Button',

'Link',

'Filter',

'TblRow',

'GridRow',

'Popup')

这是我尝试过的一个例子,但它不起作用.

DELIMITER //

CREATE PROCEDURE deleteObjectTypes(IN p_type VARCHAR(255))

BEGIN

SET @query = CONCAT ('DELETE FROM object WHERE Type NOT IN (',p_type,')');

PREPARE stmt FROM @query;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

END //

DELIMITER ;

我收到以下错误：

#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 ''List)' at line 1

运行此查询时：

CALL deleteObjectTypes("'ListGrid1','TextField1','SpinBox1','MenuButton1','ListGrid2','TextField2','SpinBox2','MenuButton2','ListGrid3','TextField3','SpinBox3','MenuButton3','ListGrid4','TextField4','SpinBox4','MenuButton4','ListGrid5','TextField5','SpinBox5','MenuButton5','ListGrid6','TextField6','SpinBox6','MenuButton6'")