Aylwin,
Thursday, April 25, 2002, 12:28:25 PM, you wrote:
AT> Hi, I'm trying to find out if MySQL is able to handle multiple users
AT> accessing a database at the same time? Can someone tell me what happens when
AT> multiple users try to do an update at the same time? Is it possible at all?
AT> If not, what whould be the best way to enable all users to do an update 'at
AT> the same time'?
Sure, MySQL supports multi-users access to the databases...
Update is an atomic operation. If you make an update in a single
statement, MySQL takes care of the data integrity. You can also use
locking tables and transactions (on InnoDB and BDB tables). Look at:
http://www.mysql.com/doc/A/N/ANSI_diff_Transactions.html
http://www.mysql.com/doc/I/n/Internal_locking.html
http://www.mysql.com/doc/T/a/Table_locking.html
AT> Regards to all,
AT> Aylwin
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.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
