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]

\s command (mysql), show connection status
Sample Database
sample tables, installing
Sams Publishing website
scripts
    Perl
         DBD module
         DBI (Database Interface)
     PHP, APIs
     tables
search and replace functions
SELECT privilege
SELECT statement
    columns
         all, retrieving
         individual, retrieving
         lists, retrieving
         multiple, retrieving
     combined queries
     database lists, retrieving
     DESCRIBE command
     error messages
    FROM clause
         INNER JOIN keyword
         JOIN keyword
     JOIN, ON keyword 2nd
     LEFT JOIN keyword
     LEFT OUTER JOIN keyword
    LIMIT clause
         limiting rows returned from queries
         skipping rows for queries
     NATURAL JOIN keyword
     ON clause, inner joins
    ORDER BY clause
         sorting on a single column
         sorting on multiple columns
         specifying sort orders
     RIGHT JOIN keyword
     RIGHT OUTER JOIN keyword
     SHOW COLUMNS command
     SHOW DATABASES command
     SHOW TABLES command
     syntax for
     tables lists, retrieving
     tables, creating
     WHERE clause
         AND operator
         BETWEEN operator
         filtering on an exact data value
         filtering on multiple values
         filtering on range of data values
         IN operator
         NOT operator
         operator precedence
         OR operator
         quotes around values
selecting, MySQL databases (mysql client program)
self-joins
semantic errors, SELECT statement
servers
     Linux/UNIX installation
     MySQL, C Language API connection
     ports
SET PASSWORD command
SHOW CHARACTER SET command
SHOW COLUMNS command, SELECT statement
SHOW CREATE VIEW command
SHOW DATABASES command, SELECT statement
SHOW DATABASES privilege
SHOW FUNCTION STATUS command
SHOW INDEXES command
SHOW KEYS command
SHOW PROCEDURE STATUS command
SHOW TABLES command 2nd
SHOW TRIGGERS command
SHOW VIEW privilege
SHOW WARNINGS command
SHUTDOWN privilege
SIN( ) function
skipping, rows in queries (LIMIT clause)
SMALLINT data type
sort orders
sorting
     columns, ORDER BY clause (SELECT statement)
     combined queries, UNION operator
     on multiple columns, ORDER BY clause (SELECT statement)
     on single columns, ORDER BY clause (SELECT statement)
source code
     Linux/UNIX server installation
     MySQL
splitting functions
SQL (Structured Query Language) 2nd
SQRT( ) function
square roots, SQRT( ) function
Standard binaries
statements [See also names of specific statements.]
     MySQL databases, executing in (mysql client ptogram)
     terminating
storage engines, tables
stored functions [See functions.]
stored routines
     creating
     creating functions
     dropping
     naming
     privileges
     showing procedures and functions
     variables
strings
     comparison operators
         BETWEEN
         BINARY
         LIKE
     converting values to numbers
     delimiters
     functions
         complete listing of (MySQL.com)
         CONCAT WS( )
         CONCAT( )
         LOCATE( )
         LOWER( )
         LPAD( )
         LTRIM( )
         NULL values
         REPLACE( )
         RPAD( )
         RTRIM( )
         SUBSTRING INDEX( )
         SUBSTRING( )
         TRIM( )
         UPPER( )
Structured Query Language (SQL) 2nd
subqueries (subselects)
     as calculated fields
     as tables
     correlated
     filtering by
     formatting
     outer queries
     syntax
     UPDATE command
     versus self-joins
subselects [See subqueries (subselects).]
SUBSTRING INDEX( ) function, string splitting
SUBSTRING( ) function, string splitting
subtraction (-) operator
SUM( ) function, data aggregation
summarizing data
summary data, filtering (HAVING clause)
SUPER privilege
superusers




Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors: Chris Newman

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