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 |