SQlite: select into?

sql sqlite

You could do:

create table bookmark1 as select * from bookmark;

sql sqlite

You can try this query:

insert into bookmark1 select * from bookmark

sql sqlite

I assume that bookmark1 is a new table that you have created which is same as the bookmark table. In that case you can use the following format.

CREATE TABLE bookmark1 AS SELECT * FROM bookmark;

Or you can also use the insert statement with subquery. For different insert statement options refer: SQL As Understood By SQLite

CodeHunter