Generating insert statements from an sqlite table

Question

Is there any tool or script available?

Answer 1

I think what you're looking for is:

sqlite x.db .dump > output.sql

This will dump the SQL to regenerate a database

Answer 2

DB Browser for SQLite supports SQL generation.

• Go to File
• Select Export
• Click to Database to SQL file...
• A popup screen will be shown.
• There you can choose export options and click OK
• It'll prompt for a location to save generated sql file.

I hope it'll help the others :)