I have an SQLite database. I have a table of data. I want to get all the data in the table as a SQL INSERT INTO statement.
For instance, consider we have the following data in the table:
id | name |
---|---|
1 | Lion |
2 | Tiger |
And, I want the SQL statement of them as follows:
INSERT INTO table_name (id, name)
VALUES (1, "Lion"),
(2, "Tiger");
Is it possible to get like this from the table using SQL?