Topics

• Getting started with MySQL
• Error codes
• Date and Time Operations
• SELECT
• Arithmetic
• Handling Time Zones
• Time with subsecond precision
• Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...
• Full-Text search

Examples

• Getting Started
• Error code 1064: Syntax error
• Date arithmetic
• SELECT all columns (*)
• SELECT with LIKE (%)
• SELECT with a LIMIT clause
• SYSDATE(), NOW(), CURDATE()
• Arithmetic Operators
• Trigonometry (SIN, COS)
• Random Numbers (RAND)
• SELECT with LIKE(_)
• SELECT with CASE or IF
• Using an index for a date and time lookup
• Retrieve the current date and time in a particular time zone.
• Convert a stored `DATE` or `DATETIME` value to another time zone.
• Retrieve stored `TIMESTAMP` values in a particular time zone
• What is my server's local time zone setting?
• What time_zone values are available in my server?
• Get the current time with millisecond precision
• Get the current time in a form that looks like a Javascript timestamp.
• Create a table with columns to store sub-second time.
• Convert a millisecond-precision date / time value to text.
• Store a Javascript timestamp into a TIMESTAMP column
• Using and misusing GROUP BY
• Misusing GROUP BY to return unpredictable results: Murphy's Law
• Misusing GROUP BY with SELECT *, and how to fix it.
• ANY_VALUE()
• Simple FULLTEXT search
• Simple BOOLEAN search
• Multi-column FULLTEXT search
• SELECT with BETWEEN