Query (basic)

SHOW SELECT

MULTIPLE COLUMN

LIMIT

SORTING RESULT

example :

SORT DIRECTION

example :

Basic Data FILTERING and WHERE

example :

Advanced FILTERING USING AND and OR

example :

IN or NOT IN

example :

LIKE ‘%’

example :

LIKE ‘_’

example :

Regular Expressions REGEXP

example :

Creating Custom Columns

example :

FUNCTION UPPER, SQRT, AVG, SUM

example :

Aggregate Functions

example :

GROUP BY

example :

SUBQUERIES 1

example :

SUBQUERIES 2

example :

JOIN TABLES

example :

OUTER JOIN

example :

UNION

example :

Text Searching

example :

INSERT

example :

MULTIPLE INSERT

example :

UPDATE

example :

DELETE

example :

CREATE TABLE

example :

NOT NULL & AUTO INCREMENT

example :

ALTER

example :

DROP

example :

RENAME TABLE

example :

VIEWS

example :