SELECT INTO statement in sqlite

Question

Does sqlite support the SELECT INTO statement?

Actually I am trying to save the data in table1 into table2 as a backup of my database before modifying the data.

When I try using the SELECT INTO statement:

SELECT * INTO equipments_backup FROM equipments; 

I get a syntax error:

"Last Error Message:near "INTO":syntax error".

Answer 1

Instead of

SELECT * INTO equipments_backup FROM equipments 

try

CREATE TABLE equipments_backup AS SELECT * FROM equipments 

Answer 2

sqlite does not support SELECT INTO.

You can probably use this form instead:

INSERT INTO equipments_backup SELECT * FROM equipments;