How to copy data from one table to another (where both have other fields too that are not in common)?

by 
INSERT INTO Destination SELECT * FROM Source;

See SQL As Understood By SQLite: INSERT for a formal definition.

Related Contents:

  1. Select first row in each GROUP BY group?
  2. Is it possible to insert multiple rows at a time in an SQLite database?
  3. SQLite – UPSERT *not* INSERT or REPLACE
  4. How to get a list of column names on Sqlite3 database?
  5. sqlite database default time value ‘now’
  6. sqlite alter table add MULTIPLE columns in a single statement
  7. How do I add a foreign key to an existing SQLite table?
  8. How to use SQL Order By statement to sort results case insensitive?
  9. Is there AUTO INCREMENT in SQLite?
  10. SQLite string contains other string query
  11. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  12. String concatenation does not work in SQLite
  13. SQLite DateTime comparison
  14. Delete column from SQLite table
  15. Declare variable in SQLite and use it
  16. SQLite – How do you join tables from different databases?
  17. SQLite – replace part of a string
  18. How to get first/top row of the table in Sqlite via Sql Query
  19. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  20. converting int to real in sqlite
  21. Drop all tables command
  22. How to create timestamp column with default value ‘now’?
  23. Update table values from another table with the same user name
  24. What are valid table names in SQLite?
  25. SQlite: select into?
  26. SQL Select between dates
  27. Run command-line SQLite query and exit
  28. SQLite Order By Date1530019888000
  29. SQLite3 Integer Max Value
  30. FULL OUTER JOIN with SQLite
  31. UPSERT *not* INSERT or REPLACE
  32. Drop column from SQLite table
  33. Select random row(s) in SQLite
  34. sqlite select with condition on date
  35. How to compare two SQLite databases on Linux
  36. SQLite Like % and _
  37. How do I add multiple “NOT LIKE ‘%?%’ in the WHERE clause of sqlite3?
  38. ON DELETE CASCADE in sqlite3
  39. What SQLite column name can be/cannot be?
  40. Whats the best SQLite data type for a long string
  41. Can SQLite handle 90 million records?
  42. Drop table in old version of SQLite where IF EXISTS is not supported
  43. how to get current datetime in SQL?
  44. SQLite syntax for If Else condition
  45. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  46. Convert integer to text in SQLite’s SELECT query?
  47. SQLite format number with 2 decimal places always
  48. SQL string value spanning multiple lines in query
  49. Copy table structure to new table in sqlite3
  50. Importing a SQLite3 dump back into the database

Leave a Comment