Presently, the GUI mode only let's you use bulk update if your table has a single-column primary key in MySQL. However, for some data sets a composite primary key is the choice we have available. Using only a single column for the update would not correctly identify the record to update. Take the …

Hi @paul_mcardle , thanks for coming by with a workaround! This worked for me as a bulk upsert although I had to slightly modify it, changing the jsonb_array_elements line to this: jsonb_array_elements('{{ step1result.data }}'::jsonb) AS d(row_data) to avoid this SQL error: syntax error at or near …

Query GUI Mode: Bulk Update Via Composite Primary Key

💬 Feature Requests

justin September 3, 2021, 7:03pm 2

@church this is a great request. For anyone viewing, this thread has some more context on what Retool current does/doesn't support: How to use composite primary key for bulk updates?

Topic		Replies	Views
How to use composite primary key for bulk updates? 💬 Queries and Resources	18	15350	June 15, 2022
Composite primary keys in Bulk queries 💬 Feature Requests	1	2188	June 20, 2022
Write Data SQL not finishing 💬 Workflows sql	19	220	April 27, 2025
Bulk upsert to PostgreSQL 💬 Queries and Resources	8	1935	June 10, 2024
Pass Json object of parameters to stored procedure 💬 Queries and Resources mssql , query-json-with-sql	10	396	March 31, 2025

Query GUI Mode: Bulk Update Via Composite Primary Key

Related topics