T



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]

\T command (mysql), query output
table joins
     Cartesian products
     cross
     equi
     inner
     multiple
     natural
     outer
     SELECT statement, FROM clause
     self-joins
tables
     altering
     autoincrementing column
     calculated columns
    columns
         foreign keys
         naming conventions
         primary keys
     creating
    data
         autocommit mode
         DELETE command
         INSERT command
         loading from file
         REPLACE command
         transactions
         UPDATE command
     default values
     dropping
     foreign keys
     lists, retrieving (SELECT statement)
     multiple, joining
     names, case sensitivity
     relational databases
         data types
         naming tables and columns
         normalization
         relationships
     samples, installing
     scripts
     storage engines
    subqueries
         as calculated fields
         correlated
         filtering by
         outer queries
         using as
     temporary 2nd
         INTERSECT simulation
         MINUS simulation
         UNION simulation
     using queries to create
     viewing indexes
     views
TAN( ) function
TCP/IP port 2nd
temporary tables 2nd
TEMPTABLE algorithm
TERMINATED BY command
terminating queries
terminating statements
test suites, Linux/UNIX server installation
TEXT data types
text, data types
time
     Coordinated Universal Time (UTC)
     data types
     formatting (DATE FORMAT( ) function)
     functions
         CONVERT TZ( )
         CURDATE( )
         DATE FORMAT( )
         EXTRACT( )
         FROM UNIXTIME( )
         NOW( )
         UNIX TIMESTAMP( )
         UTC DATE( )
         UTC TIME( )
         UTC TIMESTAMP( )
     representational formats
     zone support
TIMEDIFF( ) function, time difference computations
times, storing values in columns
TIMESTAMP data types
TINYBLOB data type
TINYINT data type
TINYTEXT data type
transactions, databases
     MySQL
     reasons for using
     rolling back
triggers
     creating audit trail
     data-maintenance
     database operations
     disabling
     dropping
     privileges
     showing information
trigonometric functions
     ACOS( )
     ASIN( )
     ATAN( )
     COS( )
     DEGREES( )
     RADIANS( )
     SIN( )
     TAN( )
TRIM( ) function, string trimming
trimming functions
     LTRIM( )
     RTRIM( )
     TRIM( )
TRUE value, conditional functions
TRUNCATE( ) function
type conversions, strings to numbers




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

Similar book on Amazon

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