Quoting DeBug [EMAIL PROTECTED]:
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
DK It depends why step 3 failed.
DK If you want to rollback the transaction
As I understand stored procedures:
Stored procedures offer a level of performance that you normally can not
replicate in code. The stored procedure actually has the query stored in the
query parser ready to rumble. You do not have to invoke network or socket
overhead in calling a long query and
Emilio-
I ran into this problem just yesterday using some PHP code. The problem was in
control logic. I executed the insert within an if statement, but failed to see
that there was another mysql_query statement outside the if block. This caused
the same insert to happen again.
Basically, in
[mailto:[EMAIL PROTECTED]
-Sent: Saturday, July 19, 2003 6:19 AM
-To: Matt Davies
-Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
-Subject: Re: Crash on mysql_real_connect on FreeBSD 4.7
-
-
-On Fri, 18 Jul 2003 14:22:13 -0600
-Matt Davies [EMAIL PROTECTED] wrote:
-
-
- Hey all,
-
- Have a very peculiar
Hey all,
Have a very peculiar problem. First off -
OS: FreeBSD 4.7
MySQL version: Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.7 (i386)
(I have also compiled 3.23.53)
The problem:
I have written a class that connects to and disconnects from the database.
Everything works fine when I