Skip to content

Instantly share code, notes, and snippets.

@zendo108

zendo108/sql

Last active July 30, 2018 22:40
Show Gist options
  • Save zendo108/d3b51dc3e9383e9a21589d9485fb8e5e to your computer and use it in GitHub Desktop.
Save zendo108/d3b51dc3e9383e9a21589d9485fb8e5e to your computer and use it in GitHub Desktop.
Download ZIP
mysql
Raw
sql
UPDATE Unit INNER JOIN UnitType
ON Unit.`UnitType_unit_type_id` = UnitType.`unit_type_id`
SET Unit.notes = UnitType.unit_type;
UPDATE Space INNER JOIN SpaceType
ON Space.`SpaceType_space_type_id` = SpaceType.`space_type_id`
SET Space.notes = SpaceType.`space_type`
UPDATE Appliance INNER JOIN AppType
ON Appliance.`AppType_app_type_id` = AppType.`app_type_id`
SET Appliance.notes = AppType.`app_type`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment