table locking
Posted: Mon Mar 10, 2008 8:02 am
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
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