Mysql returning clause equivalent

by

Unfortunately, you can’t do both insertion and deletion in one query, but you can do it all in one transaction if you are using a transactional store engine (like InnoDB). Moreover, RETURNING is supported by Oracle and PostgreSQL but not by MySQL and therefore you need to write separate delete and insert statements.

Using a transaction however, will guarantee that only the successfully copied data will be deleted from tableA. Consider the following:

begin transaction;
insert into tableB select * from tableA where 'your_condition_here';
delete from tableA where 'your_condition_here';
commit;

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  3. Count the occurrences of DISTINCT values
  4. Codeigniter – multiple database connections
  5. Column count doesn’t match value count at row 1
  6. How to add levenshtein function in mysql?
  7. How to search JSON data in MySQL?
  8. MySQL > Table doesn’t exist. But it does (or it should)
  9. Is the primary key automatically indexed in MySQL?
  10. How do I modify a MySQL column to allow NULL?
  11. Connect to mysql in a docker container from the host
  12. Is there ANY_VALUE capability for mysql 5.6?
  13. Set NOW() as Default Value for datetime datatype?
  14. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  15. SQL DELETE with JOIN another table for WHERE condition
  16. How to connect to a MySQL Data Source in Visual Studio
  17. DOs and DONTs for Indexes [closed]
  18. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  19. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  20. How can I implement single table inheritance using Laravel’s Eloquent?
  21. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  22. MySQL – ORDER BY values within IN()
  23. Integrity constraint violation: 1452 Cannot add or update a child row:
  24. How to change the mysql root password
  25. How can I set autoincrement format to 0001 in MySQL?
  26. Why MYSQL IN keyword not considering NULL values
  27. Returning records from the last 3 months only in MySQL
  28. GRANT with database name wildcard in MySQL?
  29. Using SUM on FLOAT data
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment