Intro 🎁 Have you ever written a simple multi-column IN clause, something like WHERE ROW(a, b) IN ((1, 1), (2, 2)), and […]
Read More
Remove Duplicate Rows in YugabyteDB (No Primary Key Required!)
Primary keys are your best defense against duplicates, but sometimes you inherit a table without one, or you want to de-dupe by […]
Read MoreBoost Performance by Splitting and Distributing Massive UPDATE Operations
The UPDATE statement modifies the values of specified columns in all rows that meet certain conditions. When no conditions are specified in […]
Read MoreMove Data from One Table to Another Table in One Command
You can move data from one table to another in two SQL commands, an INSERT followed by a DELETE. But it’s possible […]
Read More