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