If you specify the LOW_PRIORITY keyword, execution of the UPDATE is delayed until no other clients are reading from the table.
So, when it returns, all updates will be commited and select statement will return the correct result. "Ronan Lucio" <[EMAIL PROTECTED]> wrote: > Hi All, > I have o little (I think) doubt: > > If I use a query UPDATE LOW PRIORITY and right after > I execute a SELECT in the same table/column. > > Will I receive the correct result or only after MySQL commit > the data? > > Any help would be appreciated, > > Thanks, > Ronan > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]