SQlite: select into?

Question

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?

Answer 1

SELECT INTO isn't supported by SQLite.

Try using this form:

INSERT INTO equipments_backup  SELECT * FROM equipments;