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]

\c command (mysql), clearing current command
C Language API
     client library link
     locating compiler options
     MySQL connection
    queries
         execution
         using results
     resource efficiency
     SQL commands
calculated columns
     column aliases
     numeric operators
calculated fields, subqueries
Cartesian products
     cross joins
     table joins
cascaded views
case conversion functions
case sensitivity
     naming tables and columns
     table names
CASE statement (WHEN clause)
CEILING( ) function
character data types
character sets, database functionality
Choose Data Source window
client programs, Linux/UNIX server installation
client utilities, C Language API
client_flag argument
collations, database functionality
columns
     aliases 2nd 3rd
     all, retrieving (SELECT statement)
     constraint
     data, default values
     date data storage
     defining keys
     foreign keys
     grouping, via GROUP BY clause
     individual, retrieving (SELECT statement)
     lists, retrieving (SELECT statement)
     mismatch
    multiple columns
         retrieving (SELECT statement)
         sorting, ORDER BY clause (SELECT statement)
     naming 2nd
     NULL value
     primary keys
     single sorting, ORDER BY clause (SELECT statement)
     tables
     time data storage
combined queries
     INTERSECT operator
     MINUS operator
     sorting on UNION operator
     temporary tables
     UNION ALL operator
     UNION operator
combining WHERE clauses
     operator precedence
     via AND operator
     via BETWEEN operator
     via IN operator
     via NOT operator
     via OR operator
command-line client (mysql client), launching
commands
     CREATE DATABASE
    MySQL databases
         editing (mysql client program)
         entry of (mysql client program)
     SQL
comparison operators (strings)
     BETWEEN
     BINARY
     LIKE
     type conversion
compile-time options, configuration
compiler options
compound indexes
Comprehensive Perl Archive Network (CPAN)
CONCAT WS( ) function, string concatenation
CONCAT( ) function, string concatenation
concatenation functions
conditional functions
     CASE statement
     FALSE value
     IF( )
     IFNULL( )
     NULLIF( )
     TRUE value
conditional operators, WHERE clause (SELECT statement)
     AND
     BETWEEN
     IN
     NOT
     OR
     precedence
conditions, queries negating
Configuration wizard
connecting MySQL databases (mysql client program)
connections, port
Connector/ODBC configuration
constraints
     foreign keys
     tables
CONVERT TZ( ) function
Coordinated Universal Time (UTC)
correlated subqueries
COS( ) function
COUNT( ) function, data aggregation
CPAN (Comprehensive Perl Archive Network)
CREATE DATABASE command
CREATE FUNCTION command
CREATE INDEX command
CREATE privilege 2nd
CREATE PROCEDURE command
CREATE ROUTINE privilege
CREATE TABLE command
     options
     using queries to create tables
CREATE TABLE statements
     tables
CREATE TEMPORARY TABLE command
CREATE TEMPORARY TABLE privilege
CREATE TRIGGER command
CREATE USER command
CREATE USER privilege
CREATE VIEW command
CREATE VIEW privilege 2nd
cross joins 2nd
CURDATE( ) function




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