Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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.7k 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, 2021 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!

30.4k questions

32.5k answers

500 comments

108k users

Browse Categories

...