I'm relatively new to all of this but just about
finished setting up a transaction myself.
I'm doing something like this:
this is in php:( i also have functions set up for
"begin", "rollback" and "committ".
You should also set autocommitt to 0 .
Hope this helps!
Stuart
function run_query($sql)
{
$result = mysql_query($query);
if(!$result)
{
return false;
}else{
return true;
}
}
then:
begin();
$query = "INSERT INTO firsttable.....//first query
$res1 = run_query($query);
$query = "INSERT INTO secondtable...//second query
$res2 = run_query($query);
$query = "INSERT INTO thirdtable....//third query
$res3 = run_query($query);
if($res1 && $res2 && $res3) // If all results are true
{
commit();
echo "your insertions were successful";
}else{
echo mysql_errno($link)." :
".mysql_error($link)."\n";
rollback();
exit;
}
> 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;
> sql statement 1;
> sql 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.
>
> Thanks in advance,
>
> --
> _\\|//_
> ( O-O )
>
---------------------------o00--(_)--00o------------------------------
> Colm G. Connolly | Tel :
> +353-1-716-2851
> Department of Computer Science | Fax :
> +353-1-269-7262
> University College Dublin (UCD) | Web :
> http://darwin.ucd.ie/
> Belfield, Dublin 4 | MSN :
> [EMAIL PROTECTED]
> Éire / Republic of Ireland |
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
