# installing

sudo apt update
sudo apt install sqlite3


# creating and testing the table

sqlite3 mynamedays.db

CREATE TABLE namedata(name text NOT NULL);
INSERT INTO namedata VALUES("Test data");
SELECT * FROM namedata;

DELETE FROM namedata;
SELECT * FROM namedata;

.tables
.schema namedata
.quit


# Bash CLI examples

sqlite3 mynamedays.db "INSERT INTO namedata VALUES(\"Väinämö 17.2.\");"
sqlite3 mynamedays.db "SELECT * FROM namedata;"
sqlite3 mynamedays.db "SELECT * FROM namedata WHERE name REGEXP \"17\.2\.\";"

sqlite3 mynamedays.db "DELETE FROM namedata;"

sqlite3 mynamedays.db "INSERT INTO namedata VALUES(\"Teemu\");"
sqlite3 mynamedays.db "INSERT INTO namedata VALUES(\"Väinämö\");"
sqlite3 mynamedays.db "INSERT INTO namedata VALUES(\"Tiina\");"
sqlite3 mynamedays.db "INSERT INTO namedata VALUES(\"Erkki\");"
sqlite3 mynamedays.db "INSERT INTO namedata VALUES(\"Yrjö\");"
sqlite3 mynamedays.db "INSERT INTO namedata VALUES(\"Liisa\");"
sqlite3 mynamedays.db "SELECT * FROM namedata ORDER BY RANDOM() LIMIT 3;"