insert data from one table to another in mysql

by

You can use INSERT…SELECT syntax. Note that you can quote ‘1’ directly in the SELECT part.

INSERT INTO mt_magazine_subscription ( 
      magazine_subscription_id, 
      subscription_name, 
      magazine_id, 
      status ) 
SELECT magazine_subscription_id, 
       subscription_name, 
       magazine_id, 
       '1'
FROM tbl_magazine_subscription
ORDER BY magazine_subscription_id ASC

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. MySQL Conditional Insert
  3. How to set initial value and auto increment in MySQL?
  4. How to do a batch insert in MySQL
  5. Get the new record primary key ID from MySQL insert query?
  6. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  7. LAST_INSERT_ID() MySQL
  8. MySql Table Insert if not exist otherwise update
  9. Increment a database field by 1
  10. Prevent auto increment on MySQL duplicate insert
  11. MySQL trigger On Insert/Update events
  12. How to copy a row and insert in same table with a autoincrement field in MySQL?
  13. MySQL Error 1264: out of range value for column
  14. How do I get the ID of multiple inserted rows in MySQL?
  15. Importing a CSV to MySQL with different date format
  16. How to insert values in table with foreign key using MySQL?
  17. Field ‘id’ doesn’t have a default value?
  18. MySQL INSERT INTO … VALUES and SELECT
  19. MySQL error 1241: Operand should contain 1 column(s)
  20. How to add a where clause in a MySQL Insert statement?
  21. Reserved word in column name – insert into MySQL [duplicate]
  22. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  23. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  24. Mysql insert into 2 tables
  25. MySQL – insert data from another table merged with constants
  26. Insert data into table with result from another select query
  27. MySQL: Insert datetime into other datetime field
  28. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  29. Incorrect integer value: ” for column ‘id’ at row 1
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment