Hi.
I downloaded mysql 3.23.40 from www.mysql.com.
This site announces that this mysql version supports transaction which was
not supported in older mysql.
I was so happy to find that. So I tested that support. The case was
following.
I launched two mysql - one in A terminal window and other in B terminal
window.
And I created the table using 'create table foodb (name char(20), email
char(30)) type=BDB;'
In A I entered the followings.
mysql>set autocommit=0;
mysql>begin;
mysql>insert into foodb values('charley', '[EMAIL PROTECTED]');
**** it's just before enter COMMIT. ****
After that, I entered the followings in B.
mysql>select * from foodb;
In this case, B's mysql suspended.
But B contiued to execute above SELECT query after I entered COMMIT in A.
I think this is not true transaction. B's query should be able to be
executed before A's COMMIT query.
Oracle8(sqlplus) executes this situation correctly.
Question.
1. Please explain the above in detail.
2. If the above situation is the transaction which mysql supports, what's
difference between LOCK TABLE and TRANSACTION?
I think the only difference is functions(COMMIT, ROLLBACK) support.
3. I think the above transaction causes the performance to be lowered which
mysql is better than other RDBMS in.
I want your explanation.
Please answer to me as soon as possible because I must port my server
application using oracle 8 into that using mysql.
Thank you for reading and thanks in advance.
my email address is mailto:[EMAIL PROTECTED].
Don't send to [EMAIL PROTECTED] please.
---------------------------------------------------------------------
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
