Information Technology Grimoire

Version .0.0.1

IT Notes from various projects because I forget, and hopefully they help you too.

delete record

CREATE TABLE users (
        id INTEGER NOT NULL,
        u_first_name VARCHAR(64) NOT NULL,
        u_last_name VARCHAR(64) NOT NULL,
        u_email VARCHAR(120) NOT NULL,
        u_role VARCHAR(64) NOT NULL,
        u_status VARCHAR(64) NOT NULL, password_hash VARCHAR(128),
        PRIMARY KEY (id)
);
sqlite> SELECT * FROM users;
1|Admin|User|admin@example.com|Admin|Active|pbkdf2:sha256:150000$Q5SOagky$13b2b55fdfc8ab85923a22b8061d9c39d62dc7804692ff87a8e9246485cf03dc
sqlite> DELETE FROM users WHERE id = 1;
sqlite> SELECT * FROM users;