12 Jan 2016 / 1 min read

Updating a mysql table using a select

Hi everyone, have you ever needed to update a table in a database based on a query you just ran?

> Archived article from 2016, from the old nutellino.it: commands and versions may be out of date.

> Machine translation from Italian: the original is here.

# archive# mysql

.archive-gate.is-locked .archive-gated{filter:none;pointer-events:auto;user-select:auto;max-height:none;-webkit-mask-image:none;mask-image:none}.archive-backdrop,.archive-dialog{display:none}

Hi everyone, have you ever needed to update a table in a database based on a query you just ran?

If so, here's how you need to write it (MySql syntax)

mysql

UPDATE tabelladaaggiornare destinazione, (SELECT colonnaA,colonnaB FROM tabella where colonnaC='60') as sorgente SET destinazione.colonnaY = sorgente.colonnaA where destinazione.colonnaX=sorgente.colonnaB;

In this example, we update the tabelladaaggiornare table by setting colonnaY to the value of colonnaA extracted by the select. The update condition is the equality between colonnaX of our tabelladaaggiornare and colonnaB extracted by the select

🙂