user517491
Reputation:
Mysql how to insert none or all rows - Revert all inserted in-case of error
Is there any built in way in mysql in which it either inserts all the given rows, or reverts all inserted rows if an error(eg duplicate error) occurs?
Upvotes: 1
Views: 65
Answers (2)
Neil
Reputation: 5780
What you're referring to is commonly called a transaction. You should begin a transaction and perform a series of inserts and rollback upon failure.
See this document for further details on transactions.
Upvotes: 1
Related Questions
- How to insert on MySQL when no row affected on update in one request?
- INSERT IGNORE Inserting 0 rows
- MYSQL - Insert If Table is empty
- MySQL: INSERT Data if no record found in SELECT Statement
- INSERT only if SELECT returns no rows
- MySQL Don't INSERT If NULL Fields
- Insert missing data only in MySQL
- Insert into a table, if there is no such rows
- mysql insert multiple rows, return rows that failed
- Inserting records in Mysql with INSERT IGNORE and NULL values