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
table locking
Moderator: General Moderators
Re: table locking
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.
The MySQL website docs are helpful - do a search there for table locking.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.