Skip to content

Instantly share code, notes, and snippets.

@miklblitz

miklblitz/Обновить поля с одной таблицы в другую с соответствующими полями

Created February 17, 2020 13:40
Show Gist options
  • Save miklblitz/439ccc922629b97f4aad56215dea478a to your computer and use it in GitHub Desktop.
Save miklblitz/439ccc922629b97f4aad56215dea478a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Обновить поля с одной таблицы в другую с соответствующими полями
UPDATE need_to_update
INNER JOIN original ON need_to_update.id = original.id
SET need_to_update.field1 = original.field1,
need_to_update.field2 = original.field2,
need_to_update.field3 = original.field3,
...
WHERE condition(ex: original.updated_at like '2020-02-09%');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment