Chapter 3. Selecting Data from Tables


    Section 3.0.  Introduction

    Recipe 3.1.  Specifying Which Columns to Select

    Recipe 3.2.  Specifying Which Rows to Select

    Recipe 3.3.  Giving Better Names to Query Result Columns

    Recipe 3.4.  Using Column Aliases to Make Programs Easier to Write

    Recipe 3.5.  Combining Columns to Construct Composite Values

    Recipe 3.6.  WHERE Clauses and Column Aliases

    Recipe 3.7.  Debugging Comparison Expressions

    Recipe 3.8.  Removing Duplicate Rows

    Recipe 3.9.  Working with NULL Values

    Recipe 3.10.  Writing Comparisons Involving NULL in Programs

    Recipe 3.11.  Sorting a Result Set

    Recipe 3.12.  Using Views to Simplify Table Access

    Recipe 3.13.  Selecting Data from More Than One Table

    Recipe 3.14.  Selecting Rows from the Beginning or End of a Result Set

    Recipe 3.15.  Selecting Rows from the Middle of a Result Set

    Recipe 3.16.  Choosing Appropriate LIMIT Values

    Recipe 3.17.  What to Do When LIMIT Requires the Wrong Sort Order

    Recipe 3.18.  Calculating LIMIT Values from Expressions




MySQL Cookbook
MySQL Cookbook
ISBN: 059652708X
EAN: 2147483647
Year: 2004
Pages: 375
Authors: Paul DuBois

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net