MYSQL ÊÂÎñµÄÎÊÌâ

SQL code:

create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXECUTE SqlCMD2;
EXECUTE SqlCMD3;
COMMIT;
end

#drop PROCEDURE aa

call aa('insert into a(vName) values('B')','insert into a(vName) values('B')','insert into a(vName) values('B')')




ÏÖÔÚÓÐ3¸öSQLÃüÁҪÓÃÊÂÎñÀ´´¦ÀíÆäÔËÐÐÇé¿ö¡£ÎÒ´´½¨´æ´¢¹ý³ÌÈçÉÏ£¬ÈýÌõSQLÃüÁîµ±×ö²ÎÊý´«È룬ȻºóÊÂÎñ¿ªÊ¼£¬ÔÙÒÀ´ÎÔËÐÐ3ÌõÓï¾ä£¬ÔÙÌá½»ÊÂÎñ£¬Èç¹û·¢Éú´íÎ󣬻عöÊÂÎñ¡£

²âÊÔµÄʱºò±¨´í¡£¡£

ҪʵÏÖÕâÕâÑùµÄ²Ù×÷£¬Ó¦¸ÃÔõôÑùдÕâ¸ö´æ´¢¹ý³Ì£¿£¿

---

ɳ·¢×Ô¼º×ø£¬ÔÚÏߵȡ£

---

EXECUTE SqlCMD1; mysql²»Ö§³ÖÕâÑùÖ´Ðж¯Ì¬sqlµÄ¡£
ÒªÓÃÕâÖÖÓï·¨
PREPARE stmt_name from preparable_stmt;
EXECUTE stmt_name [USING @var_name [, @var_name] ...];
{DEALLOCATE | DROP} PREPARE stmt_name;

---

1. MYSQL²»Ö§³ÖÕâÖÖ EXECUTE SqlCMD1; °´Â¥Éϵĸü¸ÄΪ prepare / execute

SQL code:
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;

PREPARE stmt_name from SqlCMD1;
EXECUTE stmt_name;
DEALLOCATE stmt_n