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] data autocommit mode DELETE command filtering on exact values filtering on range of values grouping indexes compound CREATE INDEX command defining key columns dropping foreign key constraints with InnoDB full-text partial viewing on table INSERT command default column values inserting row using query multiple rows keys loading from file maintenance trigger REPLACE command summarizing with aggregate functions AVG( ) COUNT( ) MAX( ) MIN( ) SUM( ) transactions, MySQL UPDATE command Data Definition Language databases altering character sets collations creating dropping tables altering autoincrementing column creating default values dropping storage engines temporary using queries to create Data Manipulation Language autocommit mode DELETE command INSERT command default column values inserting row using query multiple rows loading from file REPLACE command transactions MySQL reasons for using rolling back UPDATE command Data Source Administrator window Data Source Name (DSN) data sources data types database design binary large object character date decimal integer text time variable character tables Database Interface (DBI), Perl database level routines database switch, mysql client program database-management system (DBMS) databases altering anatomy character sets collations creating designing data types naming tables and columns normalization relationships dropping lists, retrieving (SELECT statement) MySQL capturing output (mysql client program) commands, editing (mysql client program) connecting (mysql client program) connection status, viewing (mysql client program) exiting (mysql client program) query output formats (mysql client program) selecting (mysql client program) SQL command entry (mysql client program) zero record retrieval (mysql client program) reasons for using MySQL records, order of referential integrity relational SQL (Structured Query Language) tables altering autoincrementing column creating default values dropping storage engines temporary using queries to create DATE data types DATE FORMAT( ) function, format characters date functions, complete listing of (MySQL.com) date operators, representational formats DATEDIFF( ) function, date difference computations dates arithmetic operators data types formatting (DATE FORMAT( ) function) functions CONVERT TZ( ) CURDATE( ) DATE FORMAT( ) DATEDIFF( ) EXTRACT( ) NOW( ) TIMEDIFF( ) UTC DATE( ) UTC TIME( ) UTC TIMESTAMP( ) representational formats storing values in columns validation DATETIME data types DBD module, Perl connecting to MySQL executing a query fetching query data finding query information resource cleanup DBI (Database Interface), Perl DBMS (database-management system) dbname argument Debug binaries DECIMAL data type decimals, data types DECLARE command DEFAULT keyword, tables default values, tables DEGREES( ) function DELETE command, data manipulation DELETE privilege DELETE trigger delimiters character strings descending sort orders (DESC keyword) DESCRIBE command 2nd designing databases data types binary large object character date decimal integer text time variable character naming tables and columns normalization relationships Developer Zone DISTINCT keyword division (/) operator downloads MySQL installation ODBC (Open Database Connectivity) drivers, data source selection DROP DATABASE command DROP INDEX command DROP keyword, altering tables DROP privilege DROP TABLE command DROP TABLE IF EXISTS command DROP TRIGGER command DROP USER command DROP VIEW command dropping databases indexes primary keys stored routines tables triggers views DSN (Data Source Name) duplicated indexes dynamic client libraries, Linux/UNIX server installation |