| Index Entry | Section |
|---|
|
| N | | |
|---|
| NAME DBI method | 9.5.2 The DBI Interface |
| NATIONAL CHAR | 6.2 Column Types |
| NATURAL LEFT JOIN | 6.4.1.1 JOIN Syntax |
| NATURAL LEFT OUTER JOIN | 6.4.1.1 JOIN Syntax |
| NATURAL RIGHT JOIN | 6.4.1.1 JOIN Syntax |
| NATURAL RIGHT OUTER JOIN | 6.4.1.1 JOIN Syntax |
| NCHAR | 6.2 Column Types |
| newline (\n) | 6.1.1.1 Strings |
| NOT BETWEEN | 6.3.1.2 Comparison Operators |
| not equal (!=) | 6.3.1.2 Comparison Operators |
| not equal (<>) | 6.3.1.2 Comparison Operators |
| NOT IN | 6.3.1.2 Comparison Operators |
| NOT LIKE | 6.3.2.1 String Comparison Functions |
| NOT REGEXP | 6.3.2.1 String Comparison Functions |
| NOT, logical | 6.3.1.3 Logical Operators |
| NOW() | 6.3.4 Date and Time Functions |
| NUL | 6.1.1.1 Strings |
| NULL | A.5.3 Problems with NULL Values |
| NULL value | 6.1.1.4 NULL Values |
| NULLABLE DBI method | 9.5.2 The DBI Interface |
| NULLIF() | 6.3.1.4 Control Flow Functions |
| NUM_OF_FIELDS DBI method | 9.5.2 The DBI Interface |
| NUMERIC | 6.2 Column Types |
| NumGeometries() | 11.5.2.7 GeometryCollection Property Analysis Functions |
| NumInteriorRings() | 11.5.2.5 Polygon Property Analysis Functions |
| NumPoints() | 11.5.2.3 LineString Property Analysis Functions |
|
| O | | |
|---|
| OCT() | 6.3.2 String Functions |
| OCTET_LENGTH() | 6.3.2 String Functions |
| OLD_PASSWORD() | 6.3.6.2 Miscellaneous Functions |
| Operators, logical | 6.3.1.3 Logical Operators |
| OPTIMIZE TABLE | 4.5.1 OPTIMIZE TABLE Syntax |
| OR, bitwise | 6.3.6.1 Bit Functions |
| OR, logical | 6.3.1.3 Logical Operators |
| ORD() | 6.3.2 String Functions |
| ORDER BY | 6.5.4 ALTER TABLE Syntax |
| Overlaps() | 11.5.6 Functions That Test Spatial Relationships Between Geometries |
|
| P | | |
|---|
| parentheses ( and ) | 6.3.1.1 Parentheses |
| PASSWORD() | 4.2.9 Access Control, Stage 1: Connection Verification |
| PASSWORD() | 4.3.7 Setting Up Passwords |
| PASSWORD() | 6.3.6.2 Miscellaneous Functions |
| PASSWORD() | A.2.14 Ignoring user Error |
| PATH environment variable | 2.2.9 Installing a MySQL Binary Distribution |
| PATH environment variable | F. Environment Variables |
| PERIOD_ADD() | 6.3.4 Date and Time Functions |
| PERIOD_DIFF() | 6.3.4 Date and Time Functions |
| PI() | 6.3.3.2 Mathematical Functions |
| POINT | 11.4.1 MySQL Spatial Datatypes |
| Point() | 11.4.2.3 Creating Geometry Values Using MySQL-Specific Functions |
| PointFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| PointFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| PointN() | 11.5.2.3 LineString Property Analysis Functions |
| PointOnSurface() | 11.5.2.5 Polygon Property Analysis Functions |
| PointOnSurface() | 11.5.2.6 MultiPolygon Property Analysis Functions |
| PolyFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| PolyFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| POLYGON | 11.4.1 MySQL Spatial Datatypes |
| Polygon() | 11.4.2.3 Creating Geometry Values Using MySQL-Specific Functions |
| PolygonFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| PolygonFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| POSITION() | 6.3.2 String Functions |
| POW() | 6.3.3.2 Mathematical Functions |
| POWER() | 6.3.3.2 Mathematical Functions |
| prepare() DBI method | 9.5.2 The DBI Interface |
| PRIMARY KEY | 6.5.3 CREATE TABLE Syntax |
| PROCESSLIST | 4.5.7.6 SHOW PROCESSLIST |
|
| Q | | |
|---|
| QUARTER() | 6.3.4 Date and Time Functions |
| QUOTE() | 6.3.2 String Functions |
| quote() DBI method | 9.5.2 The DBI Interface |
| quoting of identifiers | 6.1.2 Database, Table, Index, Column, and Alias Names |
|
| R | | |
|---|
| RADIANS() | 6.3.3.2 Mathematical Functions |
| RAND() | 6.3.3.2 Mathematical Functions |
| REAL | 6.2 Column Types |
| ref_or_null | 5.2.5 How MySQL Optimises IS NULL |
| REGEXP | 6.3.2.1 String Comparison Functions |
| Related() | 11.5.6 Functions That Test Spatial Relationships Between Geometries |
| RELEASE_LOCK() | 6.3.6.2 Miscellaneous Functions |
| RENAME TABLE | 6.5.5 RENAME TABLE Syntax |
| REPAIR TABLE | 4.4.5 REPAIR TABLE Syntax |
| REPEAT() | 6.3.2 String Functions |
| REPLACE | 6.4.8 REPLACE Syntax |
| REPLACE ... SELECT | 6.4.3 INSERT Syntax |
| REPLACE() | 6.3.2 String Functions |
| REQUIRE GRANT option | 4.3.9.4 GRANT Options |
| RESTORE TABLE | 4.4.3 RESTORE TABLE Syntax |
| return (\r) | 6.1.1.1 Strings |
| REVERSE() | 6.3.2 String Functions |
| REVOKE | 4.3.1 GRANT and REVOKE Syntax |
| RIGHT JOIN | 6.4.1.1 JOIN Syntax |
| RIGHT OUTER JOIN | 6.4.1.1 JOIN Syntax |
| RIGHT() | 6.3.2 String Functions |
| RLIKE | 6.3.2.1 String Comparison Functions |
| ROLLBACK | 1.7.4.3 Transactions and Atomic Operations |
| ROLLBACK | 6.7.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax |
| ROLLBACK TO SAVEPOINT | 6.7.2 SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax |
| ROLLUP | 6.3.7.2 GROUP BY Modifiers |
| ROUND() | 6.3.3.2 Mathematical Functions |
| rows DBI method | 9.5.2 The DBI Interface |
| RPAD() | 6.3.2 String Functions |
| RTRIM() | 6.3.2 String Functions |
|
| S | | |
|---|
| SAVEPOINT | 6.7.2 SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax |
| SEC_TO_TIME() | 6.3.4 Date and Time Functions |
| SECOND() | 6.3.4 Date and Time Functions |
| SELECT | 6.4.1 SELECT Syntax |
| SELECT INTO TABLE | 1.7.4.2 SELECT INTO TABLE |
| SELECT speed | 5.2.3 Speed of SELECT Queries |
| SELECT, optimising | 5.2.1 EXPLAIN Syntax (Get Information About a SELECT) |
| SESSION_USER() | 6.3.6.2 Miscellaneous Functions |
| SET | 6.2 Column Types |
| SET | 6.2.3.4 The SET Type |
| SET OPTION | 5.5.6 SET Syntax |
| SET PASSWORD statement | 4.3.7 Setting Up Passwords |
| SET TRANSACTION | 6.7.4 SET TRANSACTION Syntax |
| SHA() | 6.3.6.2 Miscellaneous Functions |
| SHA1() | 6.3.6.2 Miscellaneous Functions |
| SHOW COLUMNS | 4.5.7 SHOW Syntax |
| SHOW CREATE TABLE | 4.5.7 SHOW Syntax |
| SHOW CREATE TABLE | 4.5.7.8 SHOW CREATE TABLE |
| SHOW DATABASE INFO | 4.5.7 SHOW Syntax |
| SHOW DATABASES | 4.5.7 SHOW Syntax |
| SHOW FIELDS | 4.5.7 SHOW Syntax |
| SHOW GRANTS | 4.5.7 SHOW Syntax |
| SHOW GRANTS | 4.5.7.7 SHOW GRANTS |
| SHOW INDEX | 4.5.7 SHOW Syntax |
| SHOW KEYS | 4.5.7 SHOW Syntax |
| SHOW MASTER LOGS | 4.5.7 SHOW Syntax |
| SHOW MASTER STATUS | 4.5.7 SHOW Syntax |
| SHOW PRIVILEGES | 4.5.7.11 SHOW PRIVILEGES |
| SHOW PROCESSLIST | 4.5.7 SHOW Syntax |
| SHOW PROCESSLIST | 4.5.7.6 SHOW PROCESSLIST |
| SHOW SLAVE STATUS | 4.5.7 SHOW Syntax |
| SHOW STATUS | 4.5.7 SHOW Syntax |
| SHOW TABLE STATUS | 4.5.7 SHOW Syntax |
| SHOW TABLE TYPES | 4.5.7 SHOW Syntax |
| SHOW TABLE TYPES | 4.5.7.10 SHOW TABLE TYPES |
| SHOW TABLES | 4.5.7 SHOW Syntax |
| SHOW VARIABLES | 4.5.7 SHOW Syntax |
| SHOW WARNINGS | 4.5.7 SHOW Syntax |
| SHOW WARNINGS | 4.5.7.9 SHOW WARNINGS | ERRORS |
| SIGN() | 6.3.3.2 Mathematical Functions |
| SIN() | 6.3.3.2 Mathematical Functions |
| single quote (\') | 6.1.1.1 Strings |
| SMALLINT | 6.2 Column Types |
| SOUNDEX() | 6.3.2 String Functions |
| SOUNDS LIKE | 6.3.2.1 String Comparison Functions |
| SPACE() | 6.3.2 String Functions |
| SQL_CACHE | 6.9.3 Query Cache Options in SELECT |
| SQL_NO_CACHE | 6.9.3 Query Cache Options in SELECT |
| SQRT() | 6.3.3.2 Mathematical Functions |
| SRID() | 11.5.2.1 General Geometry Property Analysis Functions |
| START TRANSACTION | 6.7.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax |
| StartPoint() | 11.5.2.3 LineString Property Analysis Functions |
| statements, GRANT | 4.3.5 Adding New Users to MySQL |
| statements, INSERT | 4.3.5 Adding New Users to MySQL |
| STD() | 6.3.7.1 GROUP BY Functions |
| STDDEV() | 6.3.7.1 GROUP BY Functions |
| STRAIGHT_JOIN | 6.4.1.1 JOIN Syntax |
| STRCMP() | 6.3.2.1 String Comparison Functions |
| string comparison functions | 6.3.2.1 String Comparison Functions |
| string functions | 6.3.2 String Functions |
| SUBDATE() | 6.3.4 Date and Time Functions |
| SUBSTRING() | 6.3.2 String Functions |
| SUBSTRING() | 6.3.2 String Functions |
| SUBSTRING_INDEX() | 6.3.2 String Functions |
| SUBTIME() | 6.3.4 Date and Time Functions |
| subtraction (-) | 6.3.3.1 Arithmetic Operations |
| SUM() | 6.3.7.1 GROUP BY Functions |
| SymDifference() | 11.5.3.2 Spatial Operators |
| SYSDATE() | 6.3.4 Date and Time Functions |
| SYSTEM_USER() | 6.3.6.2 Miscellaneous Functions |
|
