Hello, Recently in testing my GUI tool I made a comparison from the tool's dump and SQLite's command line .dump tool.
Seems .dump uses a short output of skipping the column names. According to some of my research for various databases I use one of these as options for SQL dump output: http://ajqvue.com/docs/Manual/Ajqvue_Manual.html#Preferences_Data_Export_SQL Preferences Data Export SQL Always specifying the column names list and using the database's identifier quoting character. danap. ======================= sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE datatypes (data_type_id INTEGER PRIMARY KEY AUTOINCREMENT, int_type INTEGER, real_type REAL, text_type TEXT, blob_type BLOB, date_type DATE, time_type TIME, datetime_type DATETIME, timestamp_type TIMESTAMP); INSERT INTO datatypes VALUES(1,100,200.19999999999998864,'some text', X'6162630a',1530511200000,68715000,1530343358000, 1530559371079); ======================= GUI tool: -- -- Dumping data for table "datatypes" -- INSERT INTO "datatypes" ("data_type_id", "int_type", "real_type", "text_type", "blob_type", "date_type", "time_type", "datetime_type", "timestamp_type") VALUES(1, 100, 200.2, 'some text', x'6162630a', 1530511200000, 68715000, 1530343358000, 1530559371079); _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
