QueryStash

QueryStash

Stored procedure to sync table a with table b

In this scenario, tableA has the data that customers interact with and tableB is a staging table that has updated data that tableA syncs with so tableA always has the freshest data. The query in this procedure takes the unique data from tableB, stores it in tableA, then deletes any data from tableA that is not in tableB, this way tableA doesnt have any lingering rows that are not in the original data source anymore.

Public
sql stored procedure sync mysql

Benny G

Created: Apr 7th 2022

QueryStash

QueryStash

Made with ❤️ by @Yekalb

© 2024 Query Stash. All rights reserved

TwitterFacebookEmail

Resources

BlogPricingYour First QuerySearch Your Stash

Stay up to date

Terms of ServicePrivacy Policy