Top "Multiple-records" questions

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

So I know in MySQL it's possible to insert multiple rows in one query like so: INSERT INTO table (col1,…

mysql unique-constraint multiple-records

SQL: Compare row with previous row based on a specific condition

I wanted to retrieve records from a table by comparing with previous entry (for that account). Please take a look …

sql oracle compare multiple-records

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

My innodb table has the following structure: 4 columns (CountryID, Year, %Change, Source), with the 2 columns (CountryID, Year) as the primary …

mysql sql-delete composite-primary-key multiple-records

How do I edit multiple records in one Ruby on Rails form?

I'm making a simple to-do list application to teach myself Ruby on Rails, however I've run into a problem. I …

ruby-on-rails forms checkbox multiple-records