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
