At 14:52 4/4/2001 -0700, Kristopher Briscoe wrote:
Hi,
See the sample below:
C:\mysql\bin>mysql 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 host_info (hostname char(50)) type=innobase;
Query OK, 0 rows affected (0.05 sec)
mysql> insert into host_info values ("Kris");
Query OK, 1 row affected (0.05 sec)
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from host_info;
+----------+
| hostname |
+----------+
| Kris |
+----------+
1 row in set (0.00 sec)
mysql> delete from host_info where hostname="Kris";
Query OK, 1 row affected (0.00 sec)
mysql> select * from host_info;
Empty set (0.00 sec)
mysql> rollback;
Query OK, 0 rows affected (0.03 sec)
mysql> select * from host_info;
+----------+
| hostname |
+----------+
| Kris |
+----------+
1 row in set (0.00 sec)
mysql>
Regards,
Miguel
>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
>
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil
<___/ Development Team
---------------------------------------------------------------------
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
