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: dkasak@stripped
>website: www.nusconsulting.com
