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;