On 6/17/05, [EMAIL PROTECTED] wrote:
There is one caveat: It is not currently possible to modify a table and select
from the same table in a subquery.
That is not the only problem: there is no guarantee the subquery will
only return one record. So even if MySQL wouldn't have this limitation
Can anyone tell me how I can make this work or suggest a work around?
Update table1 Set field1=(Select field1 From table1 Where field2=Some Value)
Where field2 =Another Value;
Thanks
Ed Reed [EMAIL PROTECTED] wrote on 06/17/2005 01:35:40 PM:
Can anyone tell me how I can make this work or suggest a work around?
Update table1 Set field1=(Select field1 From table1 Where field2=Some
Value)
Where field2 =Another Value;
Thanks
OK, your example must be broken (or it
Hi,
There is one caveat: It is not currently possible to modify a table and select
from the same table in a subquery.
this phrase is from
http://dev.mysql.com/tech-resources/articles/4.1/subqueries.html
solution
*
create table t as Select field1 From table1 Where field2=Some
Value
Sorry, I thought it was easy to understand.
I wanna update a field in a table with a value from the same field but from a
different record of the same table.
For example, using the query in my original message,
+--+
|RecID |FIELD1 |FIELD2 |
Could you accomplish this with an update and self join?
Ed Reed wrote:
Sorry, I thought it was easy to understand.
I wanna update a field in a table with a value from the same field but from a different record of the same table.
For example, using the query in my original message,
Thanks
[EMAIL PROTECTED] 6/17/05 2:03:02 PM
Hi,
There is one caveat: It is not currently possible to modify a table and select
from the same table in a subquery.
this phrase is from
http://dev.mysql.com/tech-resources/articles/4.1/subqueries.html
solution
*
create table t as Select
Thanks for the reply.
What do you mean by 'self join'?
Eric Bergen [EMAIL PROTECTED] 6/17/05 4:39:28 PM
Could you accomplish this with an update and self join?
Ed Reed wrote:
Sorry, I thought it was easy to understand.
I wanna update a field in a table with a value from the same field