Skip to content

Instantly share code, notes, and snippets.

@zendo108

zendo108/sql

Last active July 30, 2018 22:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save zendo108/d3b51dc3e9383e9a21589d9485fb8e5e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save zendo108/d3b51dc3e9383e9a21589d9485fb8e5e to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. zendo108 revised this gist Jul 30, 2018. 1 changed file with 9 additions and 1 deletion.
    10 changes: 9 additions & 1 deletion sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,11 @@
    UPDATE Unit INNER JOIN UnitType
    ON Unit.`UnitType_unit_type_id` = UnitType.`unit_type_id`
    SET Unit.notes = UnitType.unit_type
    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`
  2. zendo108 created this gist Jul 27, 2018.
    3 changes: 3 additions & 0 deletions sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    UPDATE Unit INNER JOIN UnitType
    ON Unit.`UnitType_unit_type_id` = UnitType.`unit_type_id`
    SET Unit.notes = UnitType.unit_type