HI Guys,

Here I a wanna know that whether sqlite supports SELECT INTO statement.

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

for that when I am using the SELECT INTO Statement a syntax error was generating as:

My query as:

SELECT * INTO equipments_backup FROM equipments;

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

Anyone's help will be appreciated.

Thank you, Monish.