No the transaction will not be rolled back...
BUT (always the BUT thing)...
If you're not carefull to open a NEW link in MySQL setting the fourth
parameter to "mysql_connect" to TRUE... PHP will not open a new link but
return the already created one... thus entering in the same transaction...
t
Andre Matos wrote:
Hi List,
Let's suppose that I have this sequence of events:
- create a connection "1"
-- start a transaction
--- create a new connection "2"
insert a new record "named B"
--- close the connection "2"
--- insert a new record "named A"
-- rollback
- close the connection "1"
Th
windows
or a graphical client.
-Original Message-
From: Andre Matos [mailto:[EMAIL PROTECTED]
Sent: Monday, February 07, 2005 6:45 PM
To: mysql@lists.mysql.com
Subject: InnoDB and Transactions
Hi List,
Let's suppose that I have this sequence of events:
- create a connection "1"
-- st
Hi List,
Let's suppose that I have this sequence of events:
- create a connection "1"
-- start a transaction
--- create a new connection "2"
insert a new record "named B"
--- close the connection "2"
--- insert a new record "named A"
-- rollback
- close the connection "1"
This sequence will
Thanks alot Cal.
-Steve.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 9:38 AM
To: Steve Bradwell; [EMAIL PROTECTED]
Subject: RE: Innodb and transactions
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('I
into it, it's a great piece of code)
HTH,
=C=
-Original Message-
From: Steve Bradwell [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 7:58 AM
To: [EMAIL PROTECTED]
Subject: Innodb and transactions
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to do begin rollback commit with
php and mysql Innodb tables?
Thanks for any and all help,
Steve.
-
Before posting, please check:
http://ww
