#sqlengine — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlengine, aggregated by home.social.
-
What's wrong with this SQL REPLACE deleting related rows?
What's wrong with this SQL REPLACE deleting related rows. The SQL code uses REPLACE instead of INSERT ON DUPLICATE. In MySQL REPLACE deletes then inserts, firing deletes on child tables. In SQL this cascades to data loss.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengine...
-
What's wrong with this SQL REPLACE deleting related rows?
What's wrong with this SQL REPLACE deleting related rows. The SQL code uses REPLACE instead of INSERT ON DUPLICATE. In MySQL REPLACE deletes then inserts, firing deletes on child tables. In SQL this cascades to data loss.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengine...
-
What's wrong with this SQL REPLACE deleting related rows?
What's wrong with this SQL REPLACE deleting related rows. The SQL code uses REPLACE instead of INSERT ON DUPLICATE. In MySQL REPLACE deletes then inserts, firing deletes on child tables. In SQL this cascades to data loss.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengine...