I'm not sure if I can use select into to import data from another table like this:
select * into bookmark1 from bookmark;
select * into
bookmark1
from bookmark;
Is it true that SQlite doesn't support this syntax? are there any other alternatives?
SELECT INTO isn't supported by SQLite.
Try using this form:
INSERT INTO equipments_backup SELECT * FROM equipments;