multiple-records – Tarik Billa

How to delete multiple rows with 2 columns as composite primary key in MySQL?

May 8, 2023 by Tarik

The answer in Oracle is: delete from cpi where (countryid, year) in ((‘AD’, 2010), (‘AF’, 2009), (‘AG’, 1992)) It’s fairly standard SQL syntax and I think MySQL is the same.

MySQL delete multiple rows in one query conditions unique to each row

February 12, 2023 by Tarik

You were very close, you can use this: DELETE FROM table WHERE (col1,col2) IN ((1,2),(3,4),(5,6)) Please see this fiddle.

How do I insert multiple values into a postgres table at once?

December 12, 2022 by Tarik

Multi-value insert syntax is: insert into table values (1,1), (1,2), (1,3), (2,1); But krokodilko’s answer is much slicker.