MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
SQL code:

create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename

insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
select 2,'2009-01-02 10:00:00','2009-01-04 10:30:00' union
select 3,'2009-01-03 10:00:00','2009-01-06 11:30:00'



´æ´¢¹ý³Ì£¬°üº¬³ö´í»Ø¹ö
SQL code:

create PROCEDURE a(ia int )
begin
start TRANSACTION;
insert into tablename values(ia+1,'2009-01-01 10:00:00','2009-01-02 11:00:00');
insert into tablename values(ia+2,'2009-01-01 10:00:00','2009-01-02 11:00:00');
insert into tablename values(ia,'2009-01-01 10:00:00','2009-01-02 11:00:00');
-- ROLLBACK;
COMMIT ;
end




±íÀïÃ棬µÚÒ»¸ö×Ö¶Îid ÊÇÖ÷¼ü£¬ÕâÑù¾Í²»ÔÊÐí²åÈëÖظ´Öµ¡£¡£
call(1),ÕâÑù²å½øÈ¥2£¬3£¬1
ÔÙCALL 3, ÕâÑù²å½øÈ¥4£¬5£¬3.¡£µ½3µÄʱºò£¬ÅжϳöÀ´Ö÷¼üÖظ´£¬Ï£ÍûÖ´Ðлعö²Ù×÷¡£¡£

Õâ¸ö´æ´¢¹ý³ÌÓ¦¸ÃÔõôÑùÐ޸ģ¿£¿Çë¸ßÊÖ°ïæ¿´Ï¡£¡£

---

ɳ·¢×Ô¼º×ø£¬²Å¶ÔµÃÆðµ³µÄÅàÑø¡£

---

×Ô¼º½â¾öÁË
SQL code:

create PROCEDURE a(ia int )
begin
[color=#FF0000]declare exit handler for sqlexception rollback;[/color]
start TRANSAC