| Index Entry | Section |
|---|
|
| G | | |
|---|
| GeomCollFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| GeomCollFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| GEOMETRY | 11.4.1 MySQL Spatial Datatypes |
| GEOMETRYCOLLECTION | 11.4.1 MySQL Spatial Datatypes |
| GeometryCollection() | 11.4.2.3 Creating Geometry Values Using MySQL-Specific Functions |
| GeometryCollectionFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| GeometryCollectionFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| GeometryFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| GeometryFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| GeometryN() | 11.5.2.7 GeometryCollection Property Analysis Functions |
| GeometryType() | 11.5.2.1 General Geometry Property Analysis Functions |
| GeomFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| GeomFromText() | 11.5.1 Functions To Convert Geometries Between Formats |
| GeomFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| GeomFromWKB() | 11.5.1 Functions To Convert Geometries Between Formats |
| GET_LOCK() | 6.3.6.2 Miscellaneous Functions |
| GLength() | 11.5.2.3 LineString Property Analysis Functions |
| GLength() | 11.5.2.4 MultiLineString Property Analysis Functions |
| GRANT | 4.3.1 GRANT and REVOKE Syntax |
| GRANT statement | 4.3.5 Adding New Users to MySQL |
| GRANT statement | 4.3.9.4 GRANT Options |
| GRANTS | 4.5.7.7 SHOW GRANTS |
| greater than (>) | 6.3.1.2 Comparison Operators |
| greater than or equal (>=) | 6.3.1.2 Comparison Operators |
| GREATEST() | 6.3.3.2 Mathematical Functions |
| GROUP BY functions | 6.3.7.1 GROUP BY Functions |
| GROUP_CONCAT() | 6.3.7.1 GROUP BY Functions |
|
| H | | |
|---|
| HANDLER | 6.4.1.2 UNION Syntax |
| HEX() | 6.3.2 String Functions |
| hexadecimal values | 6.1.1.3 Hexadecimal Values |
| HOME environment variable | 4.8.1 Overview of the Client-Side Scripts and Utilities |
| HOME environment variable | F. Environment Variables |
| host.frm, problems finding | 2.4 Post-installation Setup and Testing |
| HOUR() | 6.3.4 Date and Time Functions |
|
| I | | |
|---|
| identifiers, quoting | 6.1.2 Database, Table, Index, Column, and Alias Names |
| IF() | 6.3.1.4 Control Flow Functions |
| IFNULL() | 6.3.1.4 Control Flow Functions |
| IGNORE INDEX | 6.4.1 SELECT Syntax |
| IGNORE INDEX | 6.4.1.1 JOIN Syntax |
| IGNORE KEY | 6.4.1 SELECT Syntax |
| IGNORE KEY | 6.4.1.1 JOIN Syntax |
| IN | 6.3.1.2 Comparison Operators |
| INET_ATON() | 6.3.6.2 Miscellaneous Functions |
| INET_NTOA() | 6.3.6.2 Miscellaneous Functions |
| INNER JOIN | 6.4.1.1 JOIN Syntax |
| INSERT | 5.2.10 Speed of INSERT Queries |
| INSERT | 6.4.3 INSERT Syntax |
| INSERT ... SELECT | 6.4.3 INSERT Syntax |
| INSERT DELAYED | 6.4.4 INSERT DELAYED Syntax |
| INSERT statement, grant privileges | 4.3.5 Adding New Users to MySQL |
| INSERT() | 6.3.2 String Functions |
| INSTR() | 6.3.2 String Functions |
| INT | 6.2 Column Types |
| INTEGER | 6.2 Column Types |
| InteriorRingN() | 11.5.2.5 Polygon Property Analysis Functions |
| Intersection() | 11.5.3.2 Spatial Operators |
| Intersects() | 11.5.6 Functions That Test Spatial Relationships Between Geometries |
| INTERVAL() | 6.3.1.2 Comparison Operators |
| IS NOT NULL | 6.3.1.2 Comparison Operators |
| IS NULL | 5.2.5 How MySQL Optimises IS NULL |
| IS NULL | 6.3.1.2 Comparison Operators |
| IS NULL, and indexes | 5.4.3 How MySQL Uses Indexes |
| is_blob DBI method | 9.5.2 The DBI Interface |
| IS_FREE_LOCK() | 6.3.6.2 Miscellaneous Functions |
| is_key DBI method | 9.5.2 The DBI Interface |
| is_not_null DBI method | 9.5.2 The DBI Interface |
| is_num DBI method | 9.5.2 The DBI Interface |
| is_pri_key DBI method | 9.5.2 The DBI Interface |
| IsClosed() | 11.5.2.3 LineString Property Analysis Functions |
| IsClosed() | 11.5.2.4 MultiLineString Property Analysis Functions |
| IsEmpty() | 11.5.2.1 General Geometry Property Analysis Functions |
| ISNULL() | 6.3.1.2 Comparison Operators |
| ISOLATION LEVEL | 6.7.4 SET TRANSACTION Syntax |
| IsRing() | 11.5.2.3 LineString Property Analysis Functions |
| IsSimple() | 11.5.2.1 General Geometry Property Analysis Functions |
|
| J | | |
|---|
| JOIN | 6.4.1.1 JOIN Syntax |
|
| K | | |
|---|
| KILL | 4.5.6 KILL Syntax |
|
| L | | |
|---|
| LAST_INSERT_ID() | 1.7.4.3 Transactions and Atomic Operations |
| LAST_INSERT_ID([expr]) | 6.3.6.2 Miscellaneous Functions |
| LCASE() | 6.3.2 String Functions |
| LD_RUN_PATH environment variable | 2.6.2 Linux Notes (All Linux Versions) |
| LD_RUN_PATH environment variable | 2.6.3 Solaris Notes |
| LD_RUN_PATH environment variable | 2.7.3 Problems Using the Perl DBI/DBD Interface |
| LD_RUN_PATH environment variable | F. Environment Variables |
| LEAST() | 6.3.3.2 Mathematical Functions |
| LEFT JOIN | 5.2.7 How MySQL Optimises LEFT JOIN and RIGHT JOIN |
| LEFT JOIN | 6.4.1.1 JOIN Syntax |
| LEFT OUTER JOIN | 6.4.1.1 JOIN Syntax |
| LEFT() | 6.3.2 String Functions |
| length DBI method | 9.5.2 The DBI Interface |
| LENGTH() | 6.3.2 String Functions |
| less than (<) | 6.3.1.2 Comparison Operators |
| less than or equal (<=) | 6.3.1.2 Comparison Operators |
| LIKE | 6.3.2.1 String Comparison Functions |
| LIKE, and indexes | 5.4.3 How MySQL Uses Indexes |
| LIKE, and wildcards | 5.4.3 How MySQL Uses Indexes |
| LIMIT | 5.2.9 How MySQL Optimises LIMIT |
| LIMIT | 6.3.6.2 Miscellaneous Functions |
| LineFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| LineFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| LINESTRING | 11.4.1 MySQL Spatial Datatypes |
| LineString() | 11.4.2.3 Creating Geometry Values Using MySQL-Specific Functions |
| LineStringFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| LineStringFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| LN() | 6.3.3.2 Mathematical Functions |
| LOAD DATA INFILE | 6.4.9 LOAD DATA INFILE Syntax |
| LOAD DATA INFILE | A.5.3 Problems with NULL Values |
| LOAD_FILE() | 6.3.2 String Functions |
| LOCATE() | 6.3.2 String Functions |
| LOCATE() | 6.3.2 String Functions |
| LOCK TABLES | 6.7.3 LOCK TABLES and UNLOCK TABLES Syntax |
| LOG() | 6.3.3.2 Mathematical Functions |
| LOG10() | 6.3.3.2 Mathematical Functions |
| LOG2() | 6.3.3.2 Mathematical Functions |
| Logical operators | 6.3.1.3 Logical Operators |
| LONG | 6.2.3.2 The BLOB and TEXT Types |
| LONGBLOB | 6.2 Column Types |
| LONGTEXT | 6.2 Column Types |
| LOWER() | 6.3.2 String Functions |
| LPAD() | 6.3.2 String Functions |
| LTRIM() | 6.3.2 String Functions |
|
