在sqlite中使用SELECT INTO语句

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

实际上我在修改数据之前尝试将table1中的数据保存到table2中作为我的数据库的备份.

为此,当我使用SELECT INTOStatement时,语法错误产生为:

我的查询为:

SELECT * INTO equipments_backup FROM equipments;

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

小智.. 108

代替

SELECT * INTO equipments_backup FROM equipments

尝试

CREATE TABLE equipments_backup AS SELECT * FROM equipments

很好...`CREATE TABLE equipments_backup AS SELECT * FROM equipments` (2认同)

---

nos.. 54

sqlite不支持SELECT INTO.

您可以使用此表单:

INSERT INTO equipments_backup SELECT * FROM equipments;

1> 小智..：

---

代替

SELECT * INTO equipments_backup FROM equipments

尝试

CREATE TABLE equipments_backup AS SELECT * FROM equipments

---

很好...`CREATE TABLE equipments_backup AS SELECT * FROM equipments`

2> nos..：

---

sqlite不支持SELECT INTO.

您可以使用此表单:

INSERT INTO equipments_backup SELECT * FROM equipments;