[RESOLVED] changing lots of entries at once

[kakki]

hello there,

is there a way to change several entries in a db-table in a statement?
i have this table-structure:
table1:id1(pk),id2(pk),text
table2:id1(fk),id2(fk),newText( which holds only changes to table1 )

so far, i have done it with a temp-table like this:
1)create temp-table( with outer joins and if-statement in select )
2)drop table1
3)create table1 from temp-table
4)drop temp-table
5)drop table2
but i wonder if there is a more elegant way to solve this problem???

[barand]

I haven't yet moved on to MySQL 4.1 so
DISCLAIMER: This is pure guess and untested - use at your own risk!
In other words, backup or test on unimportant data

[sql]UPDATE table1, table2 SET table1.text = table2.newText
WHERE table1.id1 = table2.id1
AND table1.id2 = table2.id2[/sql]

[kakki]

thx...
ill try that out!

[bigpelican]

you may want to check out the update syntax of multiple table syntax.

http://dev.mysql.com/doc/refman/4.1/en/update.html