mysql -> insert into tbl (select from another table) and some default values [duplicate]

by

You simply have to do:

INSERT INTO def (catid, title, page, publish) 
SELECT catid, title, 'page','yes' from `abc`

More Related Contents:

  1. INSERT INTO…SELECT for all MySQL columns
  2. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  3. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  4. How can I make SQL case sensitive string comparison on MySQL?
  5. Import data in MySQL from a CSV file using LOAD DATA INFILE
  6. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  7. Count the occurrences of DISTINCT values
  8. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  9. How do I modify a MySQL column to allow NULL?
  10. Connect to mysql on Amazon EC2 from a remote server
  11. Docker-compose check if mysql connection is ready
  12. SQL: selecting rows where column value changed from previous row
  13. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  14. MySQL WHERE IN ()
  15. Using MySql with Entity Framework 4 and the Code-First Development CTP
  16. MySQL error 1241: Operand should contain 1 column(s)
  17. MySQL – Supertype/Subtype design
  18. How can write queries in MySQL that can parse JSON data in a column?
  19. Mysql: Order by like?
  20. MySQL Time Zones
  21. How to use django models with foreign keys in different DBs?
  22. How to change MySQL column definition?
  23. How can I undo a mysql statement that I just executed?
  24. Continue SQL query even on errors in MySQL workbench
  25. How to generate a UUIDv4 in MySQL?
  26. is php sort better than mysql “order by”?
  27. How can “set timestamp” be a slow query?
  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