(1) By AAsk (aa2e72e) on 2020-09-02 14:56:27 [source]
The command .dump ?TABLE? Render database content as SQL creates scripts such as
CREATE TABLE IF NOT EXISTS "1980-1982_F" ...
and the SQL for populating the table as
INSERT INTO "1980-1982_F" VALUES(.....)
If I want to revert to the version at the time I created the script, the script will fail when I've added a column to the table because
- INSERT INTO omits the enumeration of field names i.e. (f1,...,fn)
- The table is not dropped
- EITHER DROP TABLE IF EXISTS "1980-1982_F" followed by CREATE TABLE "1980-1982_F" ...
- OR the (enumeration of columns) after INSERT INTO
Perhaps another argument to select DROP before CREATE OR INSERT (... Field enumeration...)?