commit or rollback?

; At this point I'd like to say, in sql, if no errors then commit; else rollback end From what I read in the manual I can do one or the other (commit or rollback) but there didn't seem to be a way of conditionally doing one or the other of them. Thanks in advance

Re: commit or rollback?

then commit; else rollback end From what I read in the manual I can do one or the other (commit or rollback) but there didn't seem to be a way of conditionally doing one or the other of them. Thanks in advance

Re: commit or rollback?

Colm G. Connolly wrote: Hi all, I'm working with tables stored by the InnoDB engine and would like to be able to commit only if there are no errors generated by a group of statements like this. /* -*- sql -*- */ SET AUTOCOMMIT=0; use db1; begin work; If you specify Begin or Start Transaction, set

Re: commit or rollback?

statement 2; . . . sql statement n; At this point I'd like to say, in sql, if no errors then commit; else rollback end From what I read in the manual I can do one or the other (commit or rollback) but there didn't seem to be a way of conditionally doing one or the other of them. That's correct

Commit and rollback problem

Hi List! Hope you can help me with my problem... I am trying to incorporate commit and rollback in my sql statements... I have tried it in my web application which runs on weblogic and it work fine. However, when I migrated my web app to Tomcat, it failed to rollback when it encountered

Re: Re: Commit and rollback problem and mm.mysql

Hi. Thanks for the reply... I curious with what you mean by mysql not supporting commit and rollback coz I found this in the site : http://www.mysql.com/documentation/mysql/bychapter/manual_Refere nce.html#COMMIT Actually, Ive already tested it in my app under weblogic(and worked). I

commit and rollback commands through php

How can i say commit or rollback using php. i didnot find any commands for commit or rollback for mysql in php. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Commit and Rollback.

Hi, Will MySQL support COMMIT and ROLLBACK. Thank You Rajeev Ramanujan

beggin, commit, and rollback

Sorry if this is mundane for some, but I have searched the manual and I cannot find the answer to itTwo issues here . 1) Doesn't mysql support begin and rollback transactions? If so what is the correct procedure to make it happen. I logged in and ran my query.. select * from host_info;

Re: beggin, commit, and rollback

On Wed, Apr 04, 2001 at 02:52:39PM -0700, Kristopher Briscoe wrote: Doesn't mysql support begin and rollback transactions? If so what is the correct procedure to make it happen. I logged in and ran my query.. Depends on the table type. Check the manual for details on the different table

Re: beggin, commit, and rollback

The MySQL manual is one of the best I've seen 1) http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html #Commit-rollback 2) http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI N Regards, Gary "SuperID"

Re: beggin, commit, and rollback

At 14:52 4/4/2001 -0700, Kristopher Briscoe wrote: Hi, See the sample below: C:\mysql\binmysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create table