mySQL :: insert into table, data from another table?

by 
INSERT INTO action_2_members (campaign_id, mobile, vote, vote_date)  
SELECT campaign_id, from_number, received_msg, date_received
  FROM `received_txts`
 WHERE `campaign_id` = '8'

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Delete from two tables in one query
  3. Why would an IN condition be slower than “=” in sql?
  4. Fulltext Search with InnoDB
  5. MySQL dump by query
  6. Delete sql rows where IDs do not have a match from another table
  7. How to search multiple columns in MySQL?
  8. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  9. MySQL – Selecting data from multiple tables all with same structure but different data
  10. What does DELIMITER // do in a Trigger?
  11. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  12. MySQL equivalent of DECODE function in Oracle
  13. How do you version your database schema? [closed]
  14. Can a stored procedure/function return a table?
  15. MySQL, Get users rank
  16. Mysql: how to select groups having certain values?
  17. How to fill date gaps in MySQL?
  18. Adding a new SQL column with a default value
  19. Boolean vs tinyint(1) for boolean values in MySQL
  20. Selecting all corresponding fields using MAX and GROUP BY
  21. MySQL full text search for words with three or less letters
  22. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  23. Function for week of the month in mysql
  24. Find rows that have the same value on a column in MySQL
  25. what is the difference between GROUP BY and ORDER BY in sql
  26. How to transform vertical data into horizontal data with SQL?
  27. How to find all IDs of children recursively?
  28. How to implement a Keyword Search in MySQL?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment