Friday, November 1News That Matters
Shadow

Tag: sql

How to get SQL statement of table data

more
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?