学习mysql预处理

SET @s = 'SELECT * from  user where id=3;';
 

  PREPARE stmt2 FROM @s;  
  EXECUTE stmt2;

 DEALLOCATE PREPARE stmt2;
 
 ---------------------------------------------
 DROP PROCEDURE if exists test;
 CREATE PROCEDURE test() BEGIN
DECLARE
	i INT;
SET i = 0;
delete from abc;
WHILE
	i < 3 DO
	
	SET @sql_add = concat( 'insert into abc(score) values(', i ,')');
PREPARE sqltest FROM @sql_add;
EXECUTE sqltest;

	SET @sql_add = concat( 'insert into abc(score) values(', i*5 ,')');
PREPARE sqltest FROM @sql_add;
EXECUTE sqltest;
 DEALLOCATE PREPARE sqltest;
SET i = i + 1;
END WHILE;
END ;

CALL test();

SELECT * from abc;

 

https://www.cnblogs.com/geaozhang/p/9891338.html