MySQL Basics

Code

CREATE	create new objects in db
ALTER	alters / change the structure of the db
DROP	delete objects from the db

SELECT	retrieve data from db
INSERT	insert data into a table
UPDATE	updates existing data in a table
DELETE	deletes all records from a table, space for the records remain

Code	What it does
SELECT * FROM Table WHERE Cell LIKE 'test'	select all rows in Table where Cell contains 'test'
SELECT IdX FROM Table WHERE Cell LIKE '$Var'	select IdX from Table where Cell contains variable Var
SELECT * FROM Table ORDER BY IdX DESC LIMIT 0,10	select all rows limited by 10, order everything by IdX and from newest top to oldest bottom
SELECT * FROM Table WHERE Cell LIKE '%$Var%'	select all rows from table where cell is almost like variable Var
UPDATE `DB`.`Table` SET `Cell1` = '$Var1' WHERE `Table`.`Cell2`='$Var2'	update Table Cell2 to Var2 where Cell1 is Var1
INSERT INTO Table (Cell1, Cell2) VALUES ('Text', '$Var1')	add new row into Table with cell1 as Text and Cell2 as Var1