Sqlite - Copy one table into another one

Discussion in 'Questions (Windows Mobile)' started by fatman, Jul 30, 2015.

  1. fatman

    fatman Member Licensed User

    Hi Folks,

    I have 2 tables: a large (inifinite one) one a small one (with 10 records).
    I need to copy the 10 records into the large table.
    Tried to loop through the small table but failed.

    Any hints, snippets or how to´s are welcome!

  2. Erel

    Erel Administrator Staff Member Licensed User

    Can you post the code you tried?
  3. fatman

    fatman Member Licensed User

    Thx Erel,

    found it: INSERT INTO table1 SELECT * FROM table2

    Thank you anyway!
    Erel likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice