MySQL, HowTo

Tested with MySQL 5.6

 
MySQL
0.01 Introduction
 
1.01 Create and Use a Database
1.02 Create Tables
1.03 Data Types
1.04 Field Attributes
1.05 Field restrictions - CONSTRAINT
1.06 Delete, Rename, Change, Show Table - DROP, RENAME, ALTER, DESCRIBE
1.07 Fill or Empty a Table, one row at a time - INSERT, DELETE
1.08 See the contents of a Table - SELECT
1.09 How to write a SELECT
1.10 Fill or Empty a Table, many rows at a time                                                                                                                                                                              
 
2.01 Show certain columns and rows - SELECT
2.02 Show certain columns, rows - WHERE
2.03 Show certain columns, rows - LIKE
2.04 Show calculated values - FORMAT
2.05 Handle nonexistent values - NULL, IFNULL
2.06 More SELECT tricks - DISTINCT, LIMIT, IF
2.07 Sort the results - ORDER BY
2.08 Handle dates - CURDATE, NOW, DATE_FORMAT, STR_TO_DATE, TO_DAYS, PERIOD_DIFF
2.09 Work with character fields (strings) - LENGTH, UPPER, RTRIM, SUBSTR
 
3.01 Calculate with aggregate functions - COUNT, SUM, MIN, MAX, AVG
3.02 Calculate aggregate results for groups of rows - GROUP BY
3.03 Make fewer groups - HAVING
 
4.01 Work with more than one tables - Equi or Inner Join
4.02 Work with more than one tables - Outer, Left or Right Join
4.03 Join a table with itself - Self Join
 
5.01 Work with more than one query - Subqueries
5.02 Search in subquery results - IN, ANY, ALL
5.03 Correlated Subqueries
5.04 Search in subquery results - EXISTS
 
6.01 Change field values - UPDATE
 
7.01 Make things simpler and safer ( View ) - CREATE VIEW
7.02 Make things faster ( Index ) - CREATE INDEX, ALTER
 
8.01 Get system information - USER, DATABASE, CHARSET
 
9.01 Downloads