MySQL Unit Tests

PHP 5.2.0, MySQL 5.2.3-falcon-alpha-community-nt, Windows_NT
Basic
Literals
Numeric Integer Literals
Numeric Floating Point Literals
Date & Time Literals
String Literals
Unicode Literals
Other Literals
Operators
Math Operators
Bitwise Operators
Logical Operators
BETWEEN
INTERVAL
NULL Logic
Math Comparison Operators
String Comparison Operators
Context
Boolean Operator Context
String Context
CAST() Context
CAST() legals
CONVERT() legals
CONVERT( USING)
CAST() illegals
Numeric Integer Context
Numeric Floating Point Context
Context Mysteries
Numbers --> Strings
Numbers <-- Strings
Functions
String Functions
SOUNDEX(), SOUNDS LIKE
WEIGHT_STRING()
COERCIBILITY()
FIND_IN_SET()
NAME_CONST()
String Function MID()
String Function SUBSTRING()
String Function SUBSTRING_INDEX()
NULL Functions
Math Functions, Simple
Math Functions, Advanced
Encryption Functions
COMPRESS() and UNCOMPRESS()
Date Functions
DAYOFWEEK()
WEEKDAY()
DAYNAME()
WEEK()
YEARWEEK()
DAYOFMONTH()
DAY()
DAYOFYEAR()
Other Date Functions
STR_TO_DATE()
HOUR() Abuse
DATE_FORMAT()
TIME_FORMAT()
DATE_FORMAT() on time codes alone
TIME_FORMAT() on date codes
DATE_FORMAT() on unsupported codes
TIME_FORMAT() on unsupported codes
EXTRACT()
DATE_FORMAT() vs. EXTRACT() vs. functions
TO_DAYS(), FROM_DAYS()
UNIX_TIMESTAMP(), FROM_UNIXTIME()
TIME_TO_SEC(), SEC_TO_TIME()
GET_FORMAT()
ADDTIME()
SUBTIME()
CURDATE() CURTIME()
DATE_ADD() aka ADDDATE()
DATE_SUB() aka SUBDATE()
Patterns
LIKE
RLIKE, REGEXP
Create
Create & Insert
Case Sensitivity - Names
Multiple Rows
LIMIT
UPDATE
Column Numbers
Column Syntax Errors
Column Types
TRUNCATE
ALTER
Country Database
CountriesRaw
Countries
Views
AlternateNames
Relationships
UN
PhoneCodes
political changes
reports
JOIN