S



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




MySQL Crash Course
MySQL Crash Course
ISBN: 0672327120
EAN: 2147483647
Year: 2004
Pages: 214
Authors: Ben Forta

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