Update Multiple Rows with Different Values in a Single SQL Query
Update Multiple Rows with Different Values in a Single SQL Query: a task in Terminal-Lego-15k (Harbor dataset). You need to write a solution that updates multiple rows in a SQLite database table with different values in a single SQL query (or minimal queries). The goal is to efficiently update the…
The task
You need to write a solution that updates multiple rows in a SQLite database table with different values in a single SQL query (or minimal queries). The goal is to efficiently update the `posX` and `posY` columns based on the `id` column.
Part of PrimeIntellect/Terminal-Lego-15k.