MySQL Pocket Reference

Table of Contents
 Chapter 1. SQL Pocket Guide
 Introduction
 Organization of This Book
 Platform notes
 Conventions
 Example Data
 Using Code Examples
 How to Contact Us
 Safari® Books Online
 Acknowledgments
 Analytic Functions
 CASE Expressions: Simple
 CASE Expressions: Searched
 CAST Function
 CONNECT BY Queries
 Core CONNECT BY Syntax
 Creative CONNECT BY
 WHERE Clauses with CONNECT BY
 Joins with CONNECT BY
 Sorting CONNECT BY Results
 Loops in Hierarchical Data
 Supporting Functions and Operators
 Data Type Conversion
 Data Types: Binary Integer
 Data Types: Character String Data Types: DatetimeDB2
 MySQL
 Oracle
 PostgreSQL
 SQL Server
 Data Types: Decimal
 DB2\'s DECFLOAT Type
 DECIMAL/NUMBER Type
 Datetime Conversions: DB2
 Datetime Conversions: MySQL
 Date and Time Elements
 TO_DAYS and FROM_DAYS
 Unix Timestamp Support
 Seconds in the Day
 DATE_FORMAT and TIME_FORMAT
 Datetime Conversions: Oracle
 Datetime Conversions: PostgreSQL
 Datetime Conversions: SQL Server
 CAST and SET DATEFORMAT
 CONVERT
 DATENAME and DATEPART
 DAY, MONTH, and YEAR
 Datetime Functions: DB2
 Datetime Functions: MySQL
 Datetime Functions: Oracle
 Getting Current Date and Time Rounding and TruncatingOther Oracle Datetime Functions
 Datetime Functions: PostgreSQL
 Getting Current Date and Time
 Rounding and Truncating
 Other PostgreSQL Datetime Functions
 Datetime Functions: SQL Server
 Deleting Data
 Deleting in Order
 Deleting All Rows
 Deleting from Views and Subqueries
 Returning Deleted Data: DB2
 Returning Deleted Data: Oracle
 Returning Deleted Data: SQL Server
 Double-FROM
 EXTRACT Function
 GREATEST
 Grouping and Summarizing
 Aggregate Functions
 GROUP BY
 Listing the Detail Values
 Reducing the GROUP BY List
 Grouping Before the Join
 HAVING
 ROLLUP
 CUBE GROUPING SETSRelated Functions
 Hierarchical Queries
 Recursive WITH
 Tracking Your Depth
 Breadth-First Versus Depth-First Sorting
 Detecting Recursive Loops
 Indexes, Creating
 Indexes, Removing
 Inserting Data
 Single-Row Inserts
 Multirow Inserts
 Insert Targets
 Subquery Inserts
 Returning Inserted Values: DB2
 Returning Inserted Values: Oracle
 Returning Inserted Data: SQL Server
 Multitable Inserts
 Unconditional multitable insert
 Conditional multitable insert
 ALL versus FIRST
 Joining Tables
 The Concept of a Join
 Cross Joins
 Inner Joins
 The USING Clause
 Natural Joins Non-Equi-JoinsOuter Joins
 Left outer joins
 Interpreting nulls in an outer join
 Right outer joins
 Full outer joins
 Vendor-specific outer join syntax
 LEAST
 Literals
 Text Literals
 Numeric Literals
 Datetime Literals
 Datetime Interval Literals
 Merging Data
 Nulls
 Predicates for Nulls
 Using CASE with Nulls
 Using the COALESCE Function
 Functions for Nulls: DB2
 Functions for Nulls: MySQL
 Functions for Nulls: Oracle
 Functions for Nulls: PostgreSQL
 Functions for Nulls: SQL Server
 Numeric Conversions: DB2
 Numeric Conversions: MySQL
 Numeric Conversions: Oracle