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 |