INSERT/UPDATE and MyISAM table

Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure. Also, after deleting some rows in the

Re: INSERT/UPDATE and MyISAM table

At 12:00 PM +0900 1/23/01, Nat Sakimura wrote: ?Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure.