googlesheets-sql-sync icon indicating copy to clipboard operation
googlesheets-sql-sync copied to clipboard

Don't touch DB if data didn't change

Open jorinvo opened this issue 5 years ago • 1 comments

Rather do a comparison of data in this service than doing the drop+insert thing on the DB.

jorinvo avatar Jan 25 '20 11:01 jorinvo

As an option for people who have primary key in their Google Sheets you could use INSERT ON DUPLICATE KEY IGNORE construction.

FallenChromium avatar Aug 18 '20 11:08 FallenChromium