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]

savepoints

     definition of

     transactions, controlling 2nd 3rd 4th

scalability

     definition of

schema

     compared to databases

     definition of

scripts

    executing

         with MySQL Query Browser

searches

     case-sensitivity

SELECT

    columns

         retrieving all 2nd

         retrieving individually 2nd

         retrieving multiple 2nd

     purpose of

SELECT clauses

     sequencing 2nd

SELECT statements

     AS keyword 2nd

     concatenating fields

SELECT. 2nd 3rd [See also DISTINCT] [See also WHERE clauses] [See also queries]

self joins

     compared to subqueries

     overview 2nd

semicolons

     statements, terminating

server software. [See also client-server software]

server-based results fomatting

     compared to client-based

SET PASSWORD statements 2nd

sets

     matching regular expressions 2nd

SHOW

     overview 2nd

SHOW PROCEDURE STATUS

SHOW. [See also DESCRIBE]

signed datatypes

sing values

    checking against

         with WHERE clauses 2nd

sorting data

     by multiple columns 2nd 3rd

     case sensitivity

     in descending order 2nd

     overview 2nd

SOUNDEX() function

     overview 2nd

spaces

    removing

         RTRIM function 2nd

special characters

    regular expressions

         matching 2nd

SQL

     compared to application filtering

     overview 2nd

     syntax portability

startup problems, diagnosing 2nd

statement syntax 2nd

statements

     case sensitivity

     formatting

    SELECT

         contenating fields

    terminating

         with semicolons

     white space

statements. [See also keywords]

stopwords

     definition of

stored procedures

     creating 2nd 3rd

    cursors. [See cursors]

     disadvantages of 2nd

     dropping 2nd

     executing 2nd

     inspecting 2nd

     intelligent stored procedures, building 2nd 3rd

     overview 2nd

     parameters 2nd 3rd 4th

     uses for 2nd

string datatypes 2nd 3rd

subqueries

     as calculated fields 2nd 3rd

     combining queries with

     definition of

     filtering by 2nd 3rd 4th

     formatting effectively

     order of process

     self joins

     self joins, comparing

     Update statements

     WHERE clauses

subqueries. [See also queries]

SUM()

     overview 2nd

SUM() function

     multiple columns

syntax

     joins

syntax (statements) 2nd