Create table
CREATE TABLE table(
col1 int AUTO_INCREMENT,
col2 varchar(30), #max string length=30
col3 varchar(10) NOT NULL,
PRIMARY KEY(col1)
)
Delete table
DROP TABLE table
Rename table
RENAME TABLE table_old TO table_new
Insert row
INSERT INTO table VALUES('col1a','col2a'),('col1b','col2b') #inserted two rows
INSERT INTO table(col1_name,col2_name) VALUES('col1','col2')
Insert rows from another table (same comuln names)
INSERT INTO table(col1_name,col2_name) SELECT sol1_name,col2_name FROM table2 WHERE ...
Delete rows
DELETE FROM table WHERE col_name=100 (e.x. id=100, deletes the rows with id=100)
Add column
ALTER TABLE table ADD col varchar(10)
Delete column
ALTER TABLE table DROP COLUMN col
"VIEW" is like a reference to a portion or entire part of one or more table. It dynamically represents those info.
CREATE VIEW view AS SELECT id FROM table 1 ORDER BY col2 DESC LIMIT 10

Keywords: (This gives a comprehensive description)
SELECT
FROM
WHERE #E.x: SELECT col3, col4, col5 FROM table WHERE (col1=1 OR col1=2) AND col3='Alex';
LIMIT
IN
NOT IN
ORDER BY
ASC
DESC
AS #name the defined column as, it can rename the current columns or tables as well
CONCAT #E.X: SELECT CONCAT(city, ', ', state) AS address FROM customers UPPER #uppercase
COUNT()
GROUP BY
HAVING #similar to WHERE but used for GROUP By
UNION #similar to OR but between queries (the SELECT part need to be the same)
LIKE #E.x: SELECT city FROM customers WHERE city LIKE 'h%d'; \\starts with h and ends with d.
_ represents a single character, % represents 0 or more characters
REGEXP #E.x: . | [123] [^123] [1-7] FULLTEXT #E.x: ALTER TABLE table ADD FULLTEXT(col1) \\enables text search functionality for the column "col1" of the table "table": \\this is similar to LIKE but easier to work with