| Index Entry | Section |
|---|
|
| ! | | |
|---|
| ! (logical NOT) | 6.3.1.3 Logical Operators |
| != (not equal) | 6.3.1.2 Comparison Operators |
|
| " | | |
|---|
| " | 6.1.2 Database, Table, Index, Column, and Alias Names |
|
| % | | |
|---|
| % (modulo) | 6.3.3.2 Mathematical Functions |
| % (wildcard character) | 6.1.1.1 Strings |
|
| & | | |
|---|
| & (bitwise AND) | 6.3.6.1 Bit Functions |
| && (logical AND) | 6.3.1.3 Logical Operators |
|
| ( | | |
|---|
| () (parentheses) | 6.3.1.1 Parentheses |
| (Control-Z) \z | 6.1.1.1 Strings |
|
| * | | |
|---|
| * (multiplication) | 6.3.3.1 Arithmetic Operations |
|
| + | | |
|---|
| + (addition) | 6.3.3.1 Arithmetic Operations |
|
| - | | |
|---|
| - (subtraction) | 6.3.3.1 Arithmetic Operations |
| - (unary minus) | 6.3.3.2 Mathematical Functions |
| -p option | 4.3.8 Keeping Your Password Secure |
| -password option | 4.3.8 Keeping Your Password Secure |
|
| . | | |
|---|
| .my.cnf file | 2.6.1.7 MySQL for Windows Compared to Unix MySQL |
| .my.cnf file | 4.1.2 `my.cnf' Option Files |
| .my.cnf file | 4.1.2 `my.cnf' Option Files |
| .my.cnf file | 4.1.3.3 Using Client Programs in a Multiple-Server Environment |
| .my.cnf file | 4.2.8 Connecting to the MySQL Server |
| .my.cnf file | 4.2.12 Causes of Access denied Errors |
| .my.cnf file | 4.3.8 Keeping Your Password Secure |
| .mysql_history file | 4.8.1 Overview of the Client-Side Scripts and Utilities |
| .pid (process ID) file | 4.4.7 Setting Up a Table Maintenance Regimen |
|
| / | | |
|---|
| / (division) | 6.3.3.1 Arithmetic Operations |
| `/etc/passwd' | 4.2.2 How to Make MySQL Secure Against Crackers |
| /etc/passwd | 6.4.1 SELECT Syntax |
|
| < | | |
|---|
| < (less than) | 6.3.1.2 Comparison Operators |
| << | 3.6.8 Calculating Visits Per Day |
| << (left shift) | 6.3.6.1 Bit Functions |
| <= (less than or equal) | 6.3.1.2 Comparison Operators |
| <=> (Equal to) | 6.3.1.2 Comparison Operators |
| <> (not equal) | 6.3.1.2 Comparison Operators |
|
| = | | |
|---|
| = (equal) | 6.3.1.2 Comparison Operators |
|
| > | | |
|---|
| > (greater than) | 6.3.1.2 Comparison Operators |
| >= (greater than or equal) | 6.3.1.2 Comparison Operators |
| >> (right shift) | 6.3.6.1 Bit Functions |
|
| \ | | |
|---|
| \" (double quote) | 6.1.1.1 Strings |
| \' (single quote) | 6.1.1.1 Strings |
| \0 (ASCII 0) | 6.1.1.1 Strings |
| \\ (escape) | 6.1.1.1 Strings |
| \b (backspace) | 6.1.1.1 Strings |
| \n (newline) | 6.1.1.1 Strings |
| \r (carriage return) | 6.1.1.1 Strings |
| \t (tab) | 6.1.1.1 Strings |
| \z (Control-Z) ASCII(26) | 6.1.1.1 Strings |
|
| ^ | | |
|---|
| ^ (bitwise XOR) | 6.3.6.1 Bit Functions |
|
| _ | | |
|---|
| _ (wildcard character) | 6.1.1.1 Strings |
|
| ` | | |
|---|
| ` | 6.1.2 Database, Table, Index, Column, and Alias Names |
|
| | | | |
|---|
| | (bitwise OR) | 6.3.6.1 Bit Functions |
| || (logical OR) | 6.3.1.3 Logical Operators |
|
| ~ | | |
|---|
| ~ | 6.3.6.1 Bit Functions |
|
| A | | |
|---|
| ABS() | 6.3.3.2 Mathematical Functions |
| ACOS() | 6.3.3.2 Mathematical Functions |
| ADDDATE() | 6.3.4 Date and Time Functions |
| addition (+) | 6.3.3.1 Arithmetic Operations |
| ADDTIME() | 6.3.4 Date and Time Functions |
| AES_DECRYPT() | 6.3.6.2 Miscellaneous Functions |
| AES_ENCRYPT() | 6.3.6.2 Miscellaneous Functions |
| alias | A.5.4 Problems with alias |
| ALTER COLUMN | 6.5.4 ALTER TABLE Syntax |
| ALTER TABLE | A.7.1 Problems with ALTER TABLE. |
| ALTER TABLE | 6.5.4 ALTER TABLE Syntax |
| ANALYZE TABLE | 4.5.2 ANALYZE TABLE Syntax |
| AND, bitwise | 6.3.6.1 Bit Functions |
| AND, logical | 6.3.1.3 Logical Operators |
| Area() | 11.5.2.5 Polygon Property Analysis Functions |
| Area() | 11.5.2.6 MultiPolygon Property Analysis Functions |
| arithmetic functions | 6.3.6.1 Bit Functions |
| AS | 6.4.1 SELECT Syntax |
| AS | 6.4.1.1 JOIN Syntax |
| AsBinary() | 11.5.1 Functions To Convert Geometries Between Formats |
| ASCII() | 6.3.2 String Functions |
| ASIN() | 6.3.3.2 Mathematical Functions |
| AsText() | 11.5.1 Functions To Convert Geometries Between Formats |
| ATAN() | 6.3.3.2 Mathematical Functions |
| ATAN2() | 6.3.3.2 Mathematical Functions |
| AUTO_INCREMENT, using with DBI | 9.5.2 The DBI Interface |
| AVG() | 6.3.7.1 GROUP BY Functions |
|
| B | | |
|---|
| backspace (\b) | 6.1.1.1 Strings |
| BACKUP TABLE | 4.4.2 BACKUP TABLE Syntax |
| BdMPolyFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| BdMPolyFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| BdPolyFromText() | 11.4.2.1 Creating Geometry Values Using WKT Functions |
| BdPolyFromWKB() | 11.4.2.2 Creating Geometry Values Using WKB Functions |
| BEGIN | 6.7.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax |
| BENCHMARK() | 6.3.6.2 Miscellaneous Functions |
| BETWEEN ... AND | 6.3.1.2 Comparison Operators |
| BIGINT | 6.2 Column Types |
| BIN() | 6.3.2 String Functions |
| BINARY | 6.3.2.2 Case-Sensitivity |
| BIT | 6.2 Column Types |
| BIT_AND() | 6.3.7.1 GROUP BY Functions |
| BIT_COUNT | 3.6.8 Calculating Visits Per Day |
| BIT_COUNT() | 6.3.6.1 Bit Functions |
| BIT_LENGTH() | 6.3.2 String Functions |
| BIT_OR | 3.6.8 Calculating Visits Per Day |
| BIT_OR() | 6.3.7.1 GROUP BY Functions |
| BLOB | 6.2 Column Types |
| BLOB | 6.2.3.2 The BLOB and TEXT Types |
| BOOL | 6.2 Column Types |
| BOOLEAN | 6.2 Column Types |
| Boundary() | 11.5.2.1 General Geometry Property Analysis Functions |
| Buffer() | 11.5.3.2 Spatial Operators |
|
