paulobunga/insert_unique_data_from_other_table.md

Created June 2, 2019 14:57

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/paulobunga/27940dd8ee2fbf2e570aa65e6e565fbd.js"></script>
Save paulobunga/27940dd8ee2fbf2e570aa65e6e565fbd to your computer and use it in GitHub Desktop.

MySQL Trigger to insert distinct values while checking existing in new table

Raw

insert_unique_data_from_other_table.md

INSERT INTO locations(dhis_id, facility_name, location) SELECT DISTINCT dhis_id, facility_name, location FROM dhis_count WHERE dhis_id NOT IN(SELECT dhis_id FROM locations)