Skip to content

Instantly share code, notes, and snippets.

@thorskjold

thorskjold/SQLite

Created Mar 11, 2021
Embed
What would you like to do?
sqlite3 database.db
CREATE TABLE Læger(
Speciale NVARCHAR(70) NOT NULL,
ID CHARACTER(10) PRIMARY KEY NOT NULL,
Navn NVARCHAR(70) NOT NULL
);
INSERT INTO Læger (Speciale, ID, Navn) VALUES ('Praktiserende', 'xxxx-xxxx', 'Fornavn Efternavn');
CREATE TABLE Borger(
CPR CHARACTER(10) PRIMARY KEY NOT NULL,
Navn NVARCHAR(70) NOT NULL
);
INSERT INTO Borger (CPR, Navn) VALUES ('1234567890', 'Fornavn Efternavn');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment