samedi 30 janvier 2016

creating sqlite3 dump files with all table values

I can generate a sqlite3 dump file with

sqlite3 app.db .dump > app_dump.sql

however, if there is a row in that database which has no entry it is just left out in the dump file. This is a problem when using the dump file to read the data into another database. Is there a way to force the dump file to have all values defined in the table? So if there is no entry it just uses empty string '' or something like that? thanks carl

Aucun commentaire:

Enregistrer un commentaire