C

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