How to get SQL statement of table data
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?