MySQL Pocket Reference

Description

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;If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression. 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