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?
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
SELECT INTO isn't supported by SQLite.
Try using this form:
INSERT INTO equipments_backup SELECT * FROM equipments;