MySQL Reference Guide

• Language Elements
• Identifiers

SQL language elements:

Single Line Comment

#

--

Until the end of line, -- must be followed by a space or tab

Names for database objects such as databases, tables, views, columns, indexes, triggers, procedures etc.

Maximum length:

• Get Database Character Set and Collation

• SET FOREIGN_KEY_CHECK
• Drop existing parent tables (Removing or disable foreign key constraints)
• Duplicate entry for key error

• REGEXP and RLIKE Operators
• Session Variables
• sql_mode (Strict and Other Modes)

• How to Generate IDs

• Select Top N per Each Group
• Select and Update in Single Statement (Increment Counter avoiding Race Condition)
• Implementing Oracle NEXT_DAY Function in MySQL (Getting Next DATE by Day Name)
• Select Rows Depending on Value in Previous Row (Remove Duplicates in Each Sequence)
• Join to Different Tables Based on Condition in Table (Switch Join - Select Tables Based on Condition)

• AUTO_INCREMENT

• CONCAT
• GROUP_CONCAT
• REPLACE
• STR_TO_DATE

• CREATE TABLE
• INSERT