| Index Entry | Section |
|---|
|
| D | | |
|---|
| data, character sets | 4.6.1 The Character Set Used for Data and Sorting |
| data, importing | 4.8.8 mysqlimport, Importing Data from Text Files |
| data, loading into tables | 3.3.3 Loading Data into a Table |
| data, retrieving | 3.3.4 Retrieving Information from a Table |
| data, size | 5.4.2 Get Your Data as Small as Possible |
| database design | 5.4.1 Design Choices |
| database names, case-sensitivity | 1.7.3 MySQL Extensions To The SQL-92 Standard |
| database names, case-sensitivity | 6.1.3 Case Sensitivity in Names |
| database, deleting | 6.5.2 DROP DATABASE Syntax |
| database, mysql option | 4.8.2 mysql, The Command-line Tool |
| databases, backups | 4.4.1 Database Backups |
| databases, creating | 3.3 Creating and Using a Database |
| databases, defined | 1.2 What Is MySQL? |
| databases, displaying | 4.8.9 mysqlshow, Showing Databases, Tables, and Columns |
| databases, dumping | 4.8.6 mysqldump, Dumping Table Structure and Data |
| databases, dumping | 4.8.7 mysqlhotcopy, Copying MySQL Databases and Tables |
| databases, information about | 3.4 Getting Information About Databases and Tables |
| databases, names | 6.1.2 Database, Table, Index, Column, and Alias Names |
| databases, replicating | 4.10 Replication in MySQL |
| databases, selecting | 3.3.1 Creating and Selecting a Database |
| databases, symbolic links | 5.6.1.1 Using Symbolic Links for Databases |
| databases, using | 3.3 Creating and Using a Database |
| DataJunction | 9.2.5 Programs Known to Work with MyODBC |
| datatypes, C API | 9.1 MySQL C API |
| Date and Time types | 6.2.2 Date and Time Types |
| date calculations | 3.3.4.5 Date Calculations |
| DATE columns, problems | A.5.2 Problems Using DATE Columns |
| date functions, Y2K compliance | 1.2.5 Year 2000 Compliance |
| date types | Storage Requirements for Numeric Types |
| date types, Y2K issues | 6.2.2.1 Y2K Issues and Date Types |
| date values, problems | 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types |
| db table, sorting | 4.2.10 Access Control, Stage 2: Request Verification |
| DBI interface | 9.5.1 DBI with DBD::mysql |
| DBI Perl module | 9.5.2 The DBI Interface |
| DBI/DBD | 9.5.3 More DBI/DBD Information |
| DBUG package | E.3 The DBUG Package |
| debug, mysql option | 4.8.2 mysql, The Command-line Tool |
| debug-info, mysql option | 4.8.2 mysql, The Command-line Tool |
| debugging, client | E.2 Debugging a MySQL client |
| debugging, server | E.1 Debugging a MySQL server |
| decimal point | 6.2 Column Types |
| default hostname | 4.2.8 Connecting to the MySQL Server |
| default installation location | 2.2.5 Installation Layouts |
| default options | 4.1.2 `my.cnf' Option Files |
| default values | 5.1.1 MySQL Design Limitations/Tradeoffs |
| default values | 6.4.3 INSERT Syntax |
| default values | 6.5.3 CREATE TABLE Syntax |
| default values, BLOB and TEXT columns | 6.2.3.2 The BLOB and TEXT Types |
| default values, suppression | 1.7.5.2 Constraint NOT NULL and DEFAULT values |
| default values, suppression | 2.3.3 Typical configure Options |
| default, privileges | 4.3.4 Setting Up the Initial MySQL Privileges |
| default-character-set, mysql option | 4.8.2 mysql, The Command-line Tool |
| defaults, embedded | 9.1.15.4 Using Option Files with the Embedded Server |
| delayed_insert_limit | 6.4.4 INSERT DELAYED Syntax |
| deleting, database | 6.5.2 DROP DATABASE Syntax |
| deleting, function | 12.2.1 CREATE FUNCTION/DROP FUNCTION Syntax |
| deleting, index | 6.5.4 ALTER TABLE Syntax |
| deleting, index | 6.5.8 DROP INDEX Syntax |
| deleting, primary key | 6.5.4 ALTER TABLE Syntax |
| deleting, rows | A.5.5 Deleting Rows from Related Tables |
| deleting, table | 6.5.6 DROP TABLE Syntax |
| deletion, mysql.sock | A.4.5 How to Protect or Change the MySQL Socket File `/tmp/mysql.sock' |
| Delphi | B.1 APIs |
| Delphi program | 9.2.5 Programs Known to Work with MyODBC |
| design, choices | 5.4.1 Design Choices |
| design, issues | 1.7.6 Known Errors and Design Deficiencies in MySQL |
| design, limitations | 5.1.1 MySQL Design Limitations/Tradeoffs |
| developers, list of | C. Credits |
| development source tree | 2.3.4 Installing from the Development Source Tree |
| digits | 6.2 Column Types |
| directory structure, default | 2.2.5 Installation Layouts |
| disconnecting, from the server | 3.1 Connecting to and Disconnecting from the Server |
| disk full | A.4.3 How MySQL Handles a Full Disk |
| disk issues | 5.6 Disk Issues |
| disks, splitting data across | 2.6.1.5 Distributing Data Across Different Disks on Windows |
| display size | 6.2 Column Types |
| displaying, database information | 4.8.9 mysqlshow, Showing Databases, Tables, and Columns |
| displaying, information, SHOW | 4.5.7.1 Retrieving information about Database, Tables, Columns, and Indexes |
| displaying, table status | 4.5.7.2 SHOW TABLE STATUS |
| DNS | 5.5.5 How MySQL uses DNS |
| downgrading | 2.5 Upgrading/Downgrading MySQL |
| downloading | 2.2.1 How to Get MySQL |
| dumping, databases | 4.8.6 mysqldump, Dumping Table Structure and Data |
| dumping, databases | 4.8.7 mysqlhotcopy, Copying MySQL Databases and Tables |
| dynamic table characteristics | 7.1.2.2 Dynamic Table Characteristics |
|
| E | | |
|---|
| e-mail lists | 1.6.1.1 The MySQL Mailing Lists |
| Eiffel Wrapper | 9.9 MySQL Eiffel Wrapper |
| embedded MySQL server library | 9.1.15 libmysqld, the Embedded MySQL Server Library |
| employment with MySQL | 1.3.2 Contact Information |
| employment, contact information | 1.3.2 Contact Information |
| enable-named-commands, mysql option | 4.8.2 mysql, The Command-line Tool |
| entering, queries | 3.2 Entering Queries |
| ENUM, size | Storage Requirements for String Types |
| environment variables | 4.1.2 `my.cnf' Option Files |
| environment variables | 4.2.12 Causes of Access denied Errors |
| environment variables | 4.7.1 Overview of the Server-Side Scripts and Utilities |
| environment variables | 4.8.1 Overview of the Client-Side Scripts and Utilities |
| environment variables, list of | F. Environment Variables |
| Errcode | 4.8.11 perror, Explaining Error Codes |
| errno | 4.8.11 perror, Explaining Error Codes |
| error mesaages, can't find file | A.3.3 Problems with File Permissions |
| error messages, displaying | 4.8.11 perror, Explaining Error Codes |
| error messages, languages | 4.6.2 Non-English Error Messages |
| errors, access denied | A.2.1 Access denied Error |
| errors, checking tables for | 4.4.6.8 How to Check Tables for Errors |
| errors, common | A. Problems and Common Errors |
| errors, directory checksum | 2.6.3 Solaris Notes |
| errors, handling for UDFs | 12.2.2.4 Return Values and Error Handling |
| errors, known | 1.7.6 Known Errors and Design Deficiencies in MySQL |
| errors, linking | A.3.1 Problems When Linking with the MySQL Client Library |
| errors, list of | A.2 Common Errors When Using MySQL |
| errors, reporting | 1. General Information |
| errors, reporting | 1.6.1 MySQL Mailing Lists |
| errors, reporting | 1.6.1.3 How to Report Bugs or Problems |
| escape characters | 6.1.1 Literals: How to Write Strings and Numbers |
| estimating, query performance | 5.2.2 Estimating Query Performance |
| example option | 4.7.3 mysqld_multi, A Program for Managing Multiple MySQL Servers |
| examples, compressed tables | 4.7.4 myisampack, The MySQL Compressed Read-only Table Generator |
| examples, myisamchk output | 4.4.8 Getting Information About a Table |
| examples, queries | 3.6 Examples of Common Queries |
| Excel | 9.2.5 Programs Known to Work with MyODBC |
| execute, mysql option | 4.8.2 mysql, The Command-line Tool |
| expression aliases | 6.3.7.3 GROUP BY with Hidden Fields |
| expression aliases | 6.4.1 SELECT Syntax |
| expressions, extended | 3.3.4.7 Pattern Matching |
| extensions, to standard SQL | 1.7 MySQL Standards Compliancy |
| extracting, dates | 3.3.4.5 Date Calculations |
|
