SQlite:选择进去? [英] SQlite: select into?

问题描述

我不确定是否可以使用 select into 从另一个表中导入数据，如下所示:

I'm not sure if I can use select into to import data from another table like this:

select * into
  bookmark1 
from bookmark;    

SQlite 不支持这种语法是真的吗?还有其他选择吗?

Is it true that SQlite doesn't support this syntax? are there any other alternatives?

推荐答案

你可以试试这个查询:

insert into bookmark1 select * from bookmark

这篇关于SQlite:选择进去?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！