update table from a query result

[thedaver]

I want to use the mysql command line to do this

select rec_id from records where condition=true; update records set thisfield="beer" where rec_id in (the previous list of selected records);

Some clever person must have figured this out. I'm on 3.23.4x,... not v4 MySQL. THANKS!

"Surfinbox Shares" - A fundraising program that builds revenue from dialup Internet users.

http://www.surfinbox.com/shares/

 

[bchaigne]

Try :

update records
set thisfield="beer"
where rec_id in
(select rec_id
from records
where condition=true);


This query must be ok

 

[sleipnir214]

bchaigne:
He's already said he's running 3.x and as such subqueries aren't supported.


thedaver:
What's your condition?

Can't you just take the condition from the SELECT query and move it to the UPDATE query? Something like:

UPDATE records SET thisfield="beer" WHERE condition



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!