## How to merge two DBs with same schema

BEGIN TRANSACTION;
ATTACH 'gugus.db' AS other;
INSERT INTO "Foo" SELECT * FROM "other"."Foo";
INSERT INTO "Bar" SELECT * FROM "other"."Bar";
COMMIT;
DETACH other;


ATTACH 'bekb-2023.db' AS other;
INSERT INTO "Account" SELECT * FROM "other"."Account";
INSERT INTO "Currency" SELECT * FROM "other"."Currency";
INSERT INTO "AccountType" SELECT * FROM "other"."AccountType";
INSERT INTO "Transaction" SELECT * FROM "other"."Transaction";


## import CSV

csv Example (no headrow):
  1;foo
  2;bar

  sqlite3 foo.db -bail -cmd '.mode csv' -cmd '.separator ;' -cmd '.import foo.csv FooTable'


## Drop Column

  ALTER TABLE table DROP COLUMN column;


## Add Column

  ALTER TABLE table ADD COLUMN column NOT NULL DEFAULT 'gugus';


## Refs

[drop column TODO vote](https://stackoverflow.com/a/66399224/4415884)