mysql怎么調用存儲過程，mysql存儲過程in_在MySQL存儲過程中使用WHERE IN()

讓我們首先創建一個表-mysql>?create?table?DemoTable

->?(

->?Id?int,

mysql怎么調用存儲過程、->?Name?varchar(20)

->?);

使用插入命令在表中插入一些記錄-mysql>?insert?into?DemoTable?values(100,'Chris');

mysql>?insert?into?DemoTable?values(101,'Bob');

deletefrom和truncate table的區別、mysql>?insert?into?DemoTable?values(102,'David');

使用select語句顯示表中的所有記錄-mysql>?select?*?from?DemoTable;

這將產生以下輸出-+------+-------+

|?Id???|?Name??|

MySQL substring。+------+-------+

|??100?|?Chris?|

|??101?|?Bob???|

|??102?|?David?|

MySQL為每個數據庫建立一個文件夾。+------+-------+

3?rows?in?set?(0.00?sec)

這是創建存儲過程以使用WHERE的查詢IN()-mysql>?DELIMITER?//

mysql>?CREATE?PROCEDURE?whereInDemo(in?input?varchar(100))

存儲過程調用。->?BEGIN

->?set?@Query?=?'select?Name?from?DemoTable?';

->?set?@Query?=?CONCAT(@Query,'?where?Id?IN?(',`input`,')');

->?prepare?stmt?from?@Query;

Mysql 存儲過程。->?execute?stmt;

->?deallocate?prepare?stmt;

->?END?//

mysql>?DELIMITER?;

MySQL排序、現在您可以使用CALL命令調用存儲過程-mysql>?call?whereInDemo('100,102');

這將產生以下輸出-+-------+

|?Name??|

+-------+

|?Chris?|

|?David?|

+-------+

2?rows?in?set?(0.04?sec)