Αποτελέσματα Αναζήτησης
15 Μαρ 2010 · You can do this: UPDATE table1 SET table1.value = (SELECT table2.CODE. FROM table2 . WHERE table1.value = table2.DESC) WHERE table1.UPDATETYPE='blah'
For the single-table syntax, the UPDATE statement updates columns of existing rows in the named table with new values. The SET clause indicates which columns to modify and the values they should be given.
This tutorial shows you how to perform cross-table updates by using the MySQL UPDATE JOIN statement with the INNER JOIN or LEFT JOIN clause.
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ...
30 Μαΐ 2011 · MERGE INTO table_b USING ( SELECT id, field_2 FROM table_a ) ta ON (ta.id = table_b.id) WHEN MATCHED THEN UPDATE SET table_b.field_2 = ta.field_2
9 Ιαν 2024 · MySQL UPDATE with JOIN allows you to update a table based on data from another table or tables. You can join multiple tables using the JOIN keyword and use the SET clause to specify the columns to update and the values to set.
I can run a select but I'm not sure how to update with a join: update invoiceLine inner join terminal on terminal.ctn = invoiceLine.ctn set invoiceLine.network = ( select network.label from invoiceLine inner join terminal on terminal.ctn = invoiceLine.ctn inner join network on network.id = terminal.network ) where invoiceLine.ctn = terminal.ctn
