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 |