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 be
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,
[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
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
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
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:
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
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