How to copy data from one table to another new table in MySQL?

by

This will do what you want:

INSERT INTO table2 (st_id,uid,changed,status,assign_status)
SELECT st_id,from_uid,now(),'Pending','Assigned'
FROM table1

If you want to include all rows from table1. Otherwise you can add a WHERE statement to the end if you want to add only a subset of table1.

More Related Contents:

  1. In MySQL, can I copy one row to insert into the same table?
  2. How to copy a row and insert in same table with a autoincrement field in MySQL?
  3. MySQL: Cloning a MySQL database on the same MySql instance
  4. how to delete data from table A besides the customer service and director data in table B?
  5. Get records with max value for each group of grouped SQL results
  6. How to store multiple options in a single table?
  7. How to populate a table with a range of dates?
  8. Get the new record primary key ID from MySQL insert query?
  9. How to Perform an UPSERT so that I can use both new and old values in update part
  10. brew install mysql on macOS
  11. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  12. MySQL: multiple tables or one table with many columns? [closed]
  13. How do I check to see if a value is an integer in MySQL?
  14. Add 2 hours to current time in MySQL?
  15. Can MySQL replace multiple characters?
  16. My MySQL trigger doesn’t work, simple syntax, not complicated
  17. Using ORDER BY and GROUP BY together
  18. How can VBA connect to MySQL database in Excel?
  19. Select a column with a keyword name
  20. Sum results of a few queries and then find top 5 in SQL
  21. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  22. Use Composite Primary Key as Foreign Key
  23. How long is the SHA256 hash?
  24. how to trim leading zeros from alphanumeric text in mysql function
  25. Correct way to keep pooled connections alive (or time them out and get fresh ones) during longer inactivity for MySQL, Grails 2 app
  26. MySQL: Setting sql_mode permanently
  27. What are the max number of allowable parameters per database provider type?
  28. MySQL: how to index an “OR” clause
  29. Is it possible to count two columns in the same query
  30. mySQL query to search all tables within a database for a string?

Leave a Comment