SELECT INTO statement in sqlite
sqlite
Solution
sqlite does not support SELECT INTO.
You can probably use this form instead:
`INSERT INTO equipments_backup SELECT * FROM equipments;`
Problem
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".