You only need to lock whene you are going to run a query that contains a series of actions and they all have to happen at the same time. As for single queries, they are already atomic, so you don't need to put and locks around them.
On Mon, 11 Oct 2004 11:14:36 +0100, Melanie Courtot <[EMAIL PROTECTED]> wrote: > Hi, > I'm a bit confused by the lock mechanism under mysql. > When user A does an update on table 1, the table is automatically locked > by mysql?that means at the same time user B won't be able to modify the > same row? > Or do I have to specify the lock for each query? > And what about temporary tables? > If anybody has a simple explanation or a link on a doc.... > thanks, > Melanie > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Benjamin Arai http://www.cs.ucr.edu/~barai [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
