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" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
----- Original Message -----
From: "Kristopher Briscoe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 5:52 PM
Subject: beggin, commit, and rollback
> Sorry if this is mundane for some, but I have searched the manual and I
> cannot find the answer to it....Two 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;
>
> saw what I expected. Then I did a begin statement
> >begin;
>
> then I entered a delete statment
> >delete from host_info where hostname='kris';
>
> then did a select
> >select * from host_info where hostname='kris';
>
> my row had disappeared. Then I tried to implement a rollback.
> >rollback;
>
> all returned a success, but when I ran my query again the data was still
> gone. This is probably something simple that I am missing. Any help is
> greatly appreaciated.
>
>
> 2) Where can I find refernce to setting up and using joins?
>
> Thanks,
> Kris-
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
