At 10:55 +1000 4/17/02, Daniel Kasak wrote: >Hi all. >Can I alter a MySQL table (specifically a MyISAM) table while (MS >Access) clients are connected? >I want to add fields, not alter existing ones. >Is this likely to cause corruption? >Thanks!
MySQL won't alter the table until it can get a write lock for exclusive use. You won't corrupt the table, though the ALTER TABLE may block while it waits for the lock. > >Dan >-- >Daniel Kasak >IT Developer >* NUS Consulting Group* >Level 18, 168 Walker Street >North Sydney, NSW, Australia 2060 >T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 >email: [EMAIL PROTECTED] >website: www.nusconsulting.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
