CREATE TABLE + name of the table(unique)
CREATE TABLE users(
id INTEGER PRIMARY KEY AUTOINCREMENT,
email VARCHAR(255)
);
ALTER TABLE usesr
RENAME TO users;
ALTER TABLE users
ADD COLUMN is_students BOOLEAN;
CRUD
SQL
CREATE
READ
UPDATE
DELETE
INSERT
SELECT
==
INSERT INTO <table_name> (column1, column2,..., columnN)
By Rositsa Zlateva
Full Stack Python Developer and lecturer