Skip to content

Instantly share code, notes, and snippets.

@imidsac

imidsac/Update_two_tables.sql

Created February 12, 2020 14:29
Show Gist options
  • Save imidsac/b6e10aca3a737bbae1269354cb39367a to your computer and use it in GitHub Desktop.
Save imidsac/b6e10aca3a737bbae1269354cb39367a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Update_two_tables.sql
UPDATE enrollments
SET
(training_id, level_id, filiere_id, cycle_id) = (school_years.training_id, school_years.level_id, school_years.filiere_id, school_years.cycle_id) FROM
school_years
WHERE enrollments.school_year_id = school_years.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment