update command help please

[Anon]

Hi,

I don't know if this is even possible but any comment would be really appreciated. Two tables, products and breakf, trying to update a field in products (column_adjust) if id's in products and breakf matches. The following query gives me an error about syntax:

update products, breakf set products.column_adjust = "myvalue" where products.id = breakf.id;

I tried leaving the breafk in the update query but it says "unknown table breakf" like below:

update products set column_adjust = "myvalue" where products.id = breakf.id;

Help please 🙂

[ingooellers]

Which database you are using ?
In Mysql your first statement is illegal, because
an Update-Query can only working on one table.
For two tables you have to send 2 queries to the server.

For your special problem i suggest a small PHP-script for getting the breakf.id (via SELECT) and updating products with the result of this query.
Regards
Ingo

[Anon]

Hi Ingo, thanks for the reply... the database is an mysql database. The two tables are in one db. The reason I was trying this is to get away from updating the field values manually.

Can you give me a hint on how the php script would look like. I'm not using php with the mysql server so I'm lost.

I'm just thinking of exporting the whole table to file and filling the values in excel and import it back to the database (as a last resort of course) 🙂