sqlite insert into table select * from

by

explicitly specify the column name in the INSERT clause,

INSERT INTO destinationTable (risposta, data_ins)
SELECT STATUS risposta, DATETIME('now') data_ins 
FROM   sourceTable

More Related Contents:

  1. Best way to work with dates in Android SQLite [closed]
  2. How to split comma-separated value in SQLite?
  3. Android SQLite: Update Statement
  4. Could not allocate CursorWindow
  5. android, how to exec a sql file in sqlitedatabase
  6. Queries with prepared statements in Android?
  7. SQLite Foreign Key
  8. Android SQLite data display to ListView
  9. Android :: SQLIte Db don't insert the datas
  10. IN clause and placeholders
  11. Android Database Transaction
  12. Best place to close database connection
  13. Backup and restore SQLite database to sdcard
  14. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  15. Cursor adapter and sqlite example [closed]
  16. How to retrieve data from sqlite database in android and display it in TextView
  17. Android: column ‘_id’ does not exist
  18. Android Save images to SQLite or SDCard or memory
  19. Android Cursor with ORMLite to use in CursorAdapter
  20. Is it possible to apply primary key on the text fields in android database
  21. How to store sqlite database directly on sdcard
  22. sqlite example program in android [closed]
  23. Create SQLite database in android
  24. Android SQLite auto increment
  25. Android Device Monitor “data” folder is empty
  26. Browse SQLite database from Android Studio [closed]
  27. how to bulk insert in sqlite in android
  28. how to drop database in sqlite?
  29. SQLite database on SD card
  30. Does Android SQLite cursor load all records into memory at once?

Leave a Comment