Search code examples
sqlsqlite

SQlite: select into?

I'm not sure if I can use select into to import data from another table like this:

select * into
  bookmark1 
from bookmark;

Is it true that SQlite doesn't support this syntax? are there any other alternatives?

Solution

  • You can try this query:

    insert into bookmark1 select * from bookmark