MySQL Crash Course

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

calculated fields

     concatenating fields 2nd 3rd

         column aliases 2nd

     mathematical calculations 2nd 3rd

     overview 2nd 3rd

     subqueries as 2nd 3rd

Cartesian products

     overview 2nd

case sensitivity

     full-text searches

     sort orders

     statements

case-sensitivity

     expression matching

     searches

character classes (regular expressions)

     matching 2nd

character matching. [See basic character matching]

characters sets

     overview 2nd

     working with 2nd 3rd

CHECK TABLE

clauses

     definition of. [See also commands]

client-based results fomatting

     compared to server-based

client-server software

     overview 2nd

collation sequences

     overview 2nd

     working with 2nd 3rd

column aliases

     alternative uses

     concatening fields 2nd

columns

     commas between names

     definition of

     derived

     fully qualified names

    INSERT statement

         columns, omitting

    padded spaces

         RTRIM() function 2nd

    primary keys

         definition of 2nd

    retrieving all

         with SELECT 2nd

    retrieving individually

         with SELECT 2nd

    retrieving multiple

         with SELECT 2nd

     separating correctly

     sorting by multiple 2nd 3rd

     subquery result restrictions

columns. [See also fields]

combined queries

     creating

command line (mysql)

     overview

command line (mysql). [See mysql command line]

command-line utilities

     delimiters 2nd

commands. [See also keywords]

commas

     between column names

COMMENT keyword

     stored procedures

commiting

     definition of

commits

     default behavior, changing 2nd

     transactions, controlling 2nd

complex joins

     views, simplifying with 2nd

compound queries

     creating 2nd

     overview 2nd

     rules of 2nd

     sorting results 2nd

     WHERE clause combinations

compound quiries

     rows, eliminating/including dublicates 2nd

concaenating

     definition of

concatenating

     fields 2nd 3rd

         cloumn aliases

         column aliases

         mathematical calcualtions 2nd 3rd

connection. [See also logins]

COUNT()

     overview 2nd

COUNT() function

     DISTINCT arguments

     joins

COUNT(*) calculations

     performing through subqueries

CREATE

    auto increment

         utilizing

CREATE TABLE

     engines 2nd

CREATE TABLE statements 2nd 3rd

CREATE TABLE. [See also tables]

cross joins. [See also Cartesian products]

currency numbers, storing

cursors

     creating 2nd

     FETCH statements 2nd 3rd 4th

     opening/closing 2nd

     overview 2nd

     utilizing 2nd

customers table 2nd