Page 1 of 1

table locking

Posted: Mon Mar 10, 2008 8:02 am
by kryles
I expect this to be a rather large answer, but maybe someone can point me in the right direction (instead of blindly googling).

Eventually I want to go from Access2000 -> VB/MySql

In access there are table locks, so I'd like to know how MySql locks tables, and in what scenarios it does so.

My problem would be that a few people would be querying off the same tables, maybe even the same records so I'd like to know how to handle this before we migrate.

Any link to a good read, or any little tid bits people could offer would be much appreciated.

Thanks

Re: table locking

Posted: Mon Mar 10, 2008 10:45 am
by pickle
MyISAM (the MySQL default) has row level locking, which means no two queries can write to the same row at the same time. If you want table-wide locking, use InnoDB.

The MySQL website docs are helpful - do a search there for table locking.