UPDATE LOW PRIORITY

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 -- MySQL General Mailing List

Re: UPDATE LOW PRIORITY

At 12:26 -0300 11/1/04, Ronan Lucio 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? What is the correct result? Any help would

Re: UPDATE LOW PRIORITY

What is the correct result? The correct result is the data in the updated column after commit. For example, if I have: Table1 = - id - name INSERT INTO Table1 (id, name) VALUES (1, 'AAA') UPDATE LOW PRIORITY Table1 SET name = 'BBB' SELECT name FROM Table1 Will it return BBB? Thanks

RE: UPDATE LOW PRIORITY

[snip] Will I receive the correct result or only after MySQL commit the data? [/snip] From TFM, If you specify the LOW_PRIORITY keyword, execution of the UPDATE is delayed until no other clients are reading from the table. You can get more by RTFM at http://dev.mysql.com/doc/mysql/en/UPDATE.html

Re: UPDATE LOW PRIORITY

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

Re: UPDATE LOW PRIORITY

Jay, From TFM, If you specify the LOW_PRIORITY keyword, execution of the UPDATE is delayed until no other clients are reading from the table. Yes, I had alread read it, but it only specify when the data will be commited, not what will be returned. Let´s change the question: Before the that

Re: UPDATE LOW PRIORITY

Gleb, So, when it returns, all updates will be commited and select statement will return the correct result. It´s exactly what I´d wanted to know. Thank you very much, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: UPDATE LOW PRIORITY

At 12:46 -0300 11/1/04, Ronan Lucio wrote: What is the correct result? The correct result is the data in the updated column after commit. For example, if I have: Table1 = - id - name INSERT INTO Table1 (id, name) VALUES (1, 'AAA') UPDATE LOW PRIORITY Table1 SET name = 'BBB' SELECT name FROM

Re: UPDATE LOW PRIORITY

At 11:22 -0500 11/1/04, Paul DuBois wrote: At 12:46 -0300 11/1/04, Ronan Lucio wrote: What is the correct result? The correct result is the data in the updated column after commit. For example, if I have: Table1 = - id - name INSERT INTO Table1 (id, name) VALUES (1, 'AAA') UPDATE LOW

Re: How does update low priority work?

Andrei, Thursday, June 27, 2002, 5:19:21 AM, you wrote: AC If you execute UPDATE LOW PRIORITY table_name .. does mySQL automatically AC return or does it wait for the update to execute? (that is, is it async or AC sync)? MySQL waits for the UPDATE complete. -- For technical support

Re: How does update low priority work?

Is there any way to tell mySQL to return immediatly? Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 02:44 Subject: Re: How does update low priority work? Andrei, Thursday, June 27

How does update low priority work?

If you execute UPDATE LOW PRIORITY table_name .. does mySQL automatically return or does it wait for the update to execute? (that is, is it async or sync)? Andrei Cojocaru [EMAIL PROTECTED] - Before posting, please check