How many states did the United States consist of at the beginning of the 20th century?
Run the OPTIMIZE TABLE statement on that table
Leave a cursor fetch
An ENUM column definition may list up to 65,535 members.
Show databases in mysql
Get the day, month and year date components
Start a sequence at 100 for an InnoDB table
Event schedule start with case clause
The SQL syntax for IF branching looks like this
FULLTEXT searching supports phrase searching in Boolean mode.
Using case statement to check a range
Geometric Types in MySQL That Store Exactly One Object
Check the character set name and description
Column list in the insert statement
Two RIGHT JOIN in select command
Use a PRIMARY KEY constraint
Use FLOOR( ) if you prefer integer values to floating-point values
Sort on multiple columns
Preserving Trailing Spaces in String Columns
Modifying Existing Columns
Issue a BEGIN statement to suspend auto-commit mode, then issue the queries that make up the transaction.
Syntax for Creating a Trigger
Creating an Updatable View
Use AND to combine conditions