INSERT INTO (ShortHand)
ALTER TABLE FK:
ALTER TABLE RENAME COLUMN:
ALTER TABLE ADD COLUMN:
DROP TABLE:
ALTER TABLE DROP COLUMN:
ALTER TABLE ADD COLUMN AFTER COLUMN:
1 de noviemvbre
SELECT LIMIT (whith offset)
SELECT OFFSET
SELECT SEARCH(LIKE: Star with W)
SELECT SEARCH(LIKE: End with e)
SELECT SEARCH(LIKE: Contains)
SELECT SEARCH( NOT LIKE: Contains)
SELECT SEARCH(LIKE: Complete)
SELECT SEARCH(IN)
SELECT (ALIAS: Two Tables)
List all trainers with their pokemons
SELECT (ALIAS: Two Tables with ORDER BY)
List all trainers with their pokemons ordered desc
SELECT (ALIAS: Two Tables with AND OR & ORDER BY)
List all trainers with their pokemons type water or fire
SELECT (ALIAS: Two Tables - COUNT)
List trainer with number of pokemons
SELECT (ALIAS: Three Tables)
List all trainers with their pokemons and gyms
SELECT (INNER JOIN: Three Tables )
List all trainers with their pokemons and gym
SELECT (LEFT JOIN: Three Tables )
List all trainers with their pokemons and gym
SELECT (RIGHT JOIN: Three Tables )
List all trainers with their pokemons and gym
SELECT (UNION: Three Tables )
List all trainers, pokemons and gym in one column
CREATE VIEW
Create a view that contains all trainers with their pokemons and gym
SHOW VIEW
Show a view that contains all trainers with their pokemons and gym
UPDATE
One field
Two or more fields
DELETE
One row
ALL rows
TRANSACTION
Begin a trnsaction, delete somethinf, rollback