MySQL 存储过程中执行动态 SQL 语句

 

mysql>

02	mysql> delimiter $$

03

mysql>

04	mysql> CREATE PROCEDURE set_col_value

05	->        (in_table     VARCHAR(128),

06	->         in_column    VARCHAR(128),

07	->         in_new_value VARCHAR(1000),

08	->         in_where     VARCHAR(4000))

09

->

10

-> BEGIN

11	->    DECLARE l_sql VARCHAR(4000);

12	->    SET l_sql=CONCAT_ws(' ',

13	->                'UPDATE',in_table,

14	->                   'SET',in_column,'=',in_new_value,

15	->                ' WHERE',in_where);

16	->    SET @sql=l_sql;

17	->    PREPARE s1 FROM @sql;

18	->    EXECUTE s1;

19	->    DEALLOCATE PREPARE s1;

20

-> END$$

21	Query OK, 0 rows affected (0.00 sec)