sqlite中的SELECT INTO语句 [英] SELECT INTO statement in sqlite

问题描述

这里我想知道sqlite是否支持SELECT INTO语句.

其实我是想把table1里的数据存到table2里作为数据库的备份，然后再修改数据.

为此，当我使用 SELECT INTO 语句时，语法错误生成为:

我的查询为:

SELECT * INTO equipments_backup FROM devices;

<块引用>

"最后一条错误消息:靠近"INTO":语法错误".

解决方案

sqlite 不支持 SELECT INTO.

你或许可以改用这个表格:

INSERT INTO devices_backup SELECT * FROM devices;

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".

解决方案

sqlite does not support SELECT INTO.

You can probably use this form instead:

INSERT INTO equipments_backup SELECT * FROM equipments;

这篇关于sqlite中的SELECT INTO语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！