| Index Entry | Section |
|---|
|
| N | | |
|---|
| named pipes | 2.6.1.3 Running MySQL on Windows |
| names | 6.1.2 Database, Table, Index, Column, and Alias Names |
| names, case-sensitivity | 6.1.3 Case Sensitivity in Names |
| names, variables | 6.1.4 User Variables |
| naming, releases of MySQL | 2.2.4 Which MySQL Version to Use |
| native functions, adding | 12.2.3 Adding a New Native Function |
| native thread support | 2.2.3 Operating Systems Supported by MySQL |
| negative values | 6.1.1.2 Numbers |
| net etiquette | 1.6.1.2 Asking Questions or Reporting Bugs |
| net etiquette | 1.6.1.4 Guidelines for Answering Questions on the Mailing List |
| net_buffer_length | 4.8.2 mysql, The Command-line Tool |
| netmask notation, in mysql.user table | 4.2.9 Access Control, Stage 1: Connection Verification |
| NetWare | 2.1.4 Installing MySQL on NetWare |
| NetWare | 2.6.8 Novell NetWare Notes |
| new procedures, adding | 12.3 Adding New Procedures to MySQL |
| new users, adding | 2.2.9 Installing a MySQL Binary Distribution |
| no matching rows | A.5.6 Solving Problems with No Matching Rows |
| no-auto-rehash, mysql option | 4.8.2 mysql, The Command-line Tool |
| no-beep, mysql option | 4.8.2 mysql, The Command-line Tool |
| no-log option | 4.7.3 mysqld_multi, A Program for Managing Multiple MySQL Servers |
| no-named-commands, mysql option | 4.8.2 mysql, The Command-line Tool |
| no-pager, mysql option | 4.8.2 mysql, The Command-line Tool |
| no-tee, mysql option | 4.8.2 mysql, The Command-line Tool |
| non-delimited strings | 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types |
| Non-transactional tables | A.2.7 Some non-transactional changed tables couldn't be rolled back Error |
| NOT NULL, constraint | 1.7.5.2 Constraint NOT NULL and DEFAULT values |
| Novell NetWare | 2.1.4 Installing MySQL on NetWare |
| Novell NetWare | 2.6.8 Novell NetWare Notes |
| NULL value | 3.3.4.6 Working with NULL Values |
| NULL values, and AUTO_INCREMENT columns | A.5.3 Problems with NULL Values |
| NULL values, and indexes | 6.5.3 CREATE TABLE Syntax |
| NULL values, and TIMESTAMP columns | A.5.3 Problems with NULL Values |
| NULL values, vs. empty values | A.5.3 Problems with NULL Values |
| NULL, testing for null | 6.3.1.2 Comparison Operators |
| NULL, testing for null | 6.3.1.2 Comparison Operators |
| NULL, testing for null | 6.3.1.2 Comparison Operators |
| NULL, testing for null | 6.3.1.4 Control Flow Functions |
| numbers | 6.1.1.2 Numbers |
| numeric types | 6.2.6 Column Type Storage Requirements |
|
| O | | |
|---|
| ODBC | 9.2 MySQL ODBC Support |
| ODBC compatibility | 6.1.2 Database, Table, Index, Column, and Alias Names |
| ODBC compatibility | 6.2 Column Types |
| ODBC compatibility | 6.3.1.2 Comparison Operators |
| ODBC compatibility | 6.3.1.2 Comparison Operators |
| ODBC compatibility | 6.4.1.1 JOIN Syntax |
| ODBC compatibility | 6.5.3 CREATE TABLE Syntax |
| ODBC compatibility | D.6.20 Changes in release 3.21.15 |
| ODBC, administrator | 9.2.2 How to Fill in the Various Fields in the ODBC Administrator Program |
| odbcadmin program | 9.2.5 Programs Known to Work with MyODBC |
| OLEDB | B.1 APIs |
| one-database, mysql option | 4.8.2 mysql, The Command-line Tool |
| online location of manual | 1.1 About This Manual |
| Open Source, defined | 1.2 What Is MySQL? |
| open tables | 4.8.3 mysqladmin, Administrating a MySQL Server |
| open tables | 5.4.6 Why So Many Open tables? |
| OpenGIS | 11.1 Introduction |
| opening, tables | 5.4.7 How MySQL Opens and Closes Tables |
| opens | 4.8.3 mysqladmin, Administrating a MySQL Server |
| OpenSSL | 4.3.9 Using Secure Connections |
| operating systems, file-size limits | 1.2.4 How Big Can MySQL Tables Be? |
| operating systems, supported | 2.2.3 Operating Systems Supported by MySQL |
| operating systems, Windows versus Unix | 2.6.1.7 MySQL for Windows Compared to Unix MySQL |
| operations, arithmetic | 6.3.3.1 Arithmetic Operations |
| operators, cast | 6.3.2.2 Case-Sensitivity |
| operators, cast | 6.3.3.1 Arithmetic Operations |
| optimisation, tips | 5.2.13 Other Optimisation Tips |
| optimisations | 5.2.4 How MySQL Optimises WHERE Clauses |
| optimising, DISTINCT | 5.2.6 How MySQL Optimises DISTINCT |
| optimising, LEFT JOIN | 5.2.7 How MySQL Optimises LEFT JOIN and RIGHT JOIN |
| optimising, LIMIT | 5.2.9 How MySQL Optimises LIMIT |
| optimising, tables | 4.4.6.10 Table Optimisation |
| option files | 4.1.2 `my.cnf' Option Files |
| options, command-line | 4.1.1 mysqld Command-line Options |
| options, command-line, mysql | 4.8.2 mysql, The Command-line Tool |
| options, configure | 2.3.3 Typical configure Options |
| options, myisamchk | 4.4.6.2 General Options for myisamchk |
| options, provided by MySQL | 3. MySQL Tutorial |
| options, replication | 4.10.5 Replication Features and Known Problems |
| Oracle compatibility | 1.7.3 MySQL Extensions To The SQL-92 Standard |
| Oracle compatibility | 6.3.7.1 GROUP BY Functions |
| Oracle compatibility | 6.6.2 DESCRIBE Syntax (Get Information About Columns) |
| ORDER BY, aliases in | 6.3.7.3 GROUP BY with Hidden Fields |
| overview | 1. General Information |
|
| P | | |
|---|
| pack_isam | 4.7.4 myisampack, The MySQL Compressed Read-only Table Generator |
| pager, mysql option | 4.8.2 mysql, The Command-line Tool |
| parameters, server | 5.5.2 Tuning Server Parameters |
| partnering with MySQL AB | 1.3.1.5 Partnering |
| password encryption, reversibility of | 6.3.6.2 Miscellaneous Functions |
| password option | 4.7.3 mysqld_multi, A Program for Managing Multiple MySQL Servers |
| password, mysql option | 4.8.2 mysql, The Command-line Tool |
| password, root user | 4.3.4 Setting Up the Initial MySQL Privileges |
| passwords, for users | 4.3.2 MySQL User Names and Passwords |
| passwords, forgotten | A.4.2 How to Reset a Forgotten Root Password |
| passwords, resetting | A.4.2 How to Reset a Forgotten Root Password |
| passwords, security | 4.2.5 What the Privilege System Does |
| passwords, setting | 4.3.1 GRANT and REVOKE Syntax |
| passwords, setting | 4.3.7 Setting Up Passwords |
| passwords, setting | 5.5.6 SET Syntax |
| patches, applying | 2.3.2 Applying Patches |
| pattern matching | 3.3.4.7 Pattern Matching |
| performance, benchmarks | 5.1.5 Using Your Own Benchmarks |
| performance, disk issues | 5.6 Disk Issues |
| performance, estimating | 5.2.2 Estimating Query Performance |
| performance, improving | 4.10.8 Replication FAQ |
| performance, improving | 5.4.2 Get Your Data as Small as Possible |
| Perl API | 9.5 MySQL Perl API |
| Perl DBI/DBD, installation problems | 2.7.3 Problems Using the Perl DBI/DBD Interface |
| Perl, installing | 2.7 Perl Installation Comments |
| Perl, installing on Windows | 2.7.2 Installing ActiveState Perl on Windows |
| Perl, modules | B.1 APIs |
| permission checks, effect on speed | 5.2 Optimising SELECTs and Other Queries |
| perror | 4.8.11 perror, Explaining Error Codes |
| PHP API | 9.4 MySQL PHP API |
| port, mysql option | 4.8.2 mysql, The Command-line Tool |
| portability | 5.1.2 Portability |
| portability, types | 6.2.5 Using Column Types from Other Database Engines |
| porting, to other systems | E. Porting to Other Systems |
| post-install, multiple servers | 4.1.3 Running Multiple MySQL Servers on the Same Machine |
| post-installation, setup and testing | 2.4 Post-installation Setup and Testing |
| PostgreSQL compatibility | 1.7.3 MySQL Extensions To The SQL-92 Standard |
| prices, support | 1.4.1 Support Offered by MySQL AB |
| PRIMARY KEY, constraint | 1.7.5.1 Constraint PRIMARY KEY / UNIQUE |
| primary key, deleting | 6.5.4 ALTER TABLE Syntax |
| privilege information, location | 4.2.7 Privileges Provided by MySQL |
| privilege system | 4.2.5 What the Privilege System Does |
| privilege system, described | 4.2.6 How the Privilege System Works |
| privilege, changes | 4.2.10 Access Control, Stage 2: Request Verification |
| privileges, access | 4.2 General Security Issues and the MySQL Access Privilege System |
| privileges, adding | 4.3.5 Adding New Users to MySQL |
| privileges, default | 4.3.4 Setting Up the Initial MySQL Privileges |
| privileges, display | 4.5.7.7 SHOW GRANTS |
| privileges, granting | 4.3.1 GRANT and REVOKE Syntax |
| privileges, revoking | 4.3.1 GRANT and REVOKE Syntax |
| problems, access denied errors | A.2.1 Access denied Error |
| problems, common errors | A. Problems and Common Errors |
| problems, compiling | 2.3.5 Problems Compiling MySQL? |
| problems, DATE columns | A.5.2 Problems Using DATE Columns |
| problems, date values | 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types |
| problems, installing on IBM-AIX | 2.6.6.4 IBM-AIX notes |
| problems, installing on Solaris | 2.6.3 Solaris Notes |
| problems, installing Perl | 2.7.3 Problems Using the Perl DBI/DBD Interface |
| problems, linking | A.3.1 Problems When Linking with the MySQL Client Library |
| problems, ODBC | 9.2.7 Reporting Problems with MyODBC |
| problems, reporting | 1.6.1.3 How to Report Bugs or Problems |
| problems, starting the server | 2.4.2 Problems Starting the MySQL Server |
| problems, table locking | 5.3.2 Table Locking Issues |
| problems, timezone | A.4.6 Time Zone Problems |
| procedures, adding | 12.3 Adding New Procedures to MySQL |
| procedures, stored | 1.7.4.4 Stored Procedures and Triggers |
| process support | 2.2.3 Operating Systems Supported by MySQL |
| processes, display | 4.5.7.6 SHOW PROCESSLIST |
| processing, arguments | 12.2.2.3 Argument Processing |
| products, selling | 1.4.3 MySQL Licenses |
| programs, client | 9.1.13 Building Client Programs |
| programs, contributed | B. Contributed Programs |
| programs, crash-me | 5.1.2 Portability |
| programs, list of | 4.7.1 Overview of the Server-Side Scripts and Utilities |
| programs, list of | 4.8.1 Overview of the Client-Side Scripts and Utilities |
| prompt command | 4.8.2 mysql, The Command-line Tool |
| prompt, mysql option | 4.8.2 mysql, The Command-line Tool |
| prompts, meanings | 3.2 Entering Queries |
| pronunciation, MySQL | 1.2 What Is MySQL? |
| Protocol mismatch | 2.5.5 Upgrading from Version 3.20 to 3.21 |
| protocol, mysql option | 4.8.2 mysql, The Command-line Tool |
| protocol, mysql option | 4.8.8 mysqlimport, Importing Data from Text Files |
| Python API | 9.7 MySQL Python API |
|
