mysql – move rows from one table to another

by

A simple INSERT INTO SELECT statement:

INSERT INTO persons_table SELECT * FROM customer_table WHERE person_name="tom";

DELETE FROM customer_table WHERE person_name="tom";

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. When to use single quotes, double quotes, and backticks in MySQL
  3. Trouble with UTF-8 characters; what I see is not what I stored
  4. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  5. MySQL: Grant **all** privileges on database
  6. How to escape apostrophe (‘) in MySql?
  7. Is it possible to have function-based index in MySQL?
  8. Multiple Updates in MySQL
  9. SQL split comma separated row [duplicate]
  10. MySql Error: Can’t update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
  11. Does MySQL ignore null values on unique constraints?
  12. What does the KEY keyword mean?
  13. MySQL – Subtracting value from previous row, group by
  14. MySQL utf8mb4, Errors when saving Emojis
  15. How to count items in comma separated list MySQL
  16. How to store unicode in MySQL?
  17. mysql after insert trigger which updates another table’s column
  18. Search for string within text column in MySQL
  19. Error renaming a column in MySQL
  20. Mysql database sync between two databases
  21. Is there a simple way to convert MySQL data into Title Case?
  22. Clear MySQL query cache without restarting server
  23. Mysql select recursive get all child with multiple level
  24. MySQL Error: Incorrect usage of UPDATE and LIMIT
  25. Mysql insert into 2 tables
  26. How do you stop MySQL on a Mac OS install?
  27. Replace null with 0 in MySQL
  28. Array data type, split string,
  29. Trouble with GROUP_CONCAT and Longtext in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment