0 votes
1 view
in Python by (20.3k points)

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

select * into

  bookmark1 

from bookmark;    

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

1 Answer

0 votes
by (40.4k points)

SELECT INTO isn't supported by SQLite.

Try using this form:

INSERT INTO equipments_backup  SELECT * FROM equipments;

Related questions

0 votes
1 answer
asked Jul 20, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jan 5 in SQL by Appu (6.1k points)
0 votes
1 answer
asked Dec 12, 2020 in SQL by Appu (6.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...