Mysql: the Definitive Guide to Using, Programming, and Administering Mysql 4.1 and 5.0

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

each() function

edit command editing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

editing commands list 2nd editing commands, list of 2nd

editing member entries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th effectiveness of 2nd 3rd 4th 5th 6th

efficient statement execution 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

ego command

ELT() function 2nd

embedded MySQL server (libmysqld) 2nd 3rd embedded server applications 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th embedded server applications, producing application executable binary 2nd 3rd 4th 5th 6th

embedded server communication 2nd 3rd 4th

embedded server communication functions (C API) 2nd

embedded server library 2nd 3rd 4th 5th 6th 7th 8th

enabling 2nd 3rd 4th enabling autocommit mode

enabling log files

enabling options 2nd 3rd 4th 5th 6th enabling strict mode 2nd

enabling traditional mode 2nd 3rd 4th ENCODE() function

encoding special characters 2nd 3rd 4th 5th 6th 7th 8th

encoding special characters in SQL statements 2nd 3rd

ENCRYPT() function

encrypted SSL connections, configuring 2nd 3rd 4th 5th 6th 7th

end_html() function

ending 2nd 3rd 4th

ENDPOINT() function

ENGINE clauses 2nd 3rd 4th

ENGINE option 2nd 3rd

enter_scores() function

entering multiple statements into single lines 2nd 3rd

entire databases, recovering 2nd

ENUM 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th

ENUM columns 2nd

ENUM string data type 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

ENUM, handling invalid data values 2nd ENUM, value storage ENVELOPE() function

environment 2nd

environment variables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th environment variables (Perl DBI) 2nd 3rd 4th 5th

equal sign (=) comparison operator 2nd 3rd

EQUALS() function

equi-joins 2nd

err()

err() handle method (Perl DBI)

error checking 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th error handling 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th

error log operation 2nd 3rd error logs 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th

error logs, Unix operation 2nd 3rd 4th error logs, Windows operation 2nd

error messages 2nd

error messages, selecting language for 2nd 3rd 4th

error-reporting 2nd 3rd 4th 5th 6th

error-reporting function (C API) 2nd error-reporting functions (C API) 2nd error_count 2nd

error_count session-only system variable

ERROR_FOR_DIVIDE_BY_ZERO attribute

ERROR_FOR_DIVISION_BY_ZERO SQL mode value

ERROR_FOR_DIVISION_BY_ZERO value 2nd errstr() 2nd

errstr() handle method (Perl DBI) 2nd

escape character 2nd escape sequences 2nd 3rd 4th 5th 6th 7th

escape sequences as escapeHTML() function

escapeSimple () 2nd

escapeSimple () method (PEAR DB module)

escaping quotes 2nd 3rd 4th

Essentials packages 2nd

Essentials packages (MySQL 4.1.5) 2nd

establishing 2nd 3rd 4th

establishing file location 2nd 3rd 4th

establishing foreign key relationships 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

establishing passwords 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

ESTERIORRING() function

event-id columns

event-id columns (grade-keeping table database scenario grade_event tables

EXAMPLE 2nd

example programs 2nd

EXAMPLE storage engine 2nd

EXAMPLE storage engines 2nd 3rd 4th 5th 6th examples of 2nd 3rd exclamation point (!) logical operator

EXECUTE 2nd 3rd 4th 5th 6th 7th 8th

execute () 2nd 3rd 4th execute () method (PEAR DB module) 2nd

EXECUTE privilege 2nd

EXECUTE privileges (grant tables)

EXECUTE statement

execute() 2nd

execute() method 2nd 3rd

execute() statement handle method (Perl DBI) 2nd execute_array()

execute_array() statement handle method (Perl DBI) executeMultiple () 2nd

executeMultiple () method (PEAR DB module) executing 2nd 3rd

execution environment 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th

execution environment (API selection) 2nd 3rd 4th 5th 6th

existence of, determining

EXISTS subqueries 2nd 3rd 4th 5th 6th 7th 8th exit command EXP() function

expiration 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd

expiration, age-based expiration

expiration, automating 2nd 3rd

expiration, log rotation 2nd 3rd 4th 5th 6th 7th 8th 9th expiration, numbered log files 2nd

expiration, replication-related expiration 2nd 3rd 4th

expiration, Unix operation 2nd 3rd expiration, Windows operation 2nd 3rd

expire_logs_days 2nd expire_logs_days system variable

expire_logs_days variable

expire_numbered_logs.pl script

expiring log files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th

EXPLAIN 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

EXPLAIN statement 2nd 3rd 4th

EXPLAIN statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th

EXPLAIN statements, efficient statement execution 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

EXPLAIN statements, verifying optimizer operation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

explicit

explicit data types

explicit table locking 2nd 3rd 4th

explode() function

EXPORRT_SET() function

expression elements 2nd

expressions 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th

expressions, references in 2nd EXTENDED 2nd EXTENDED option 2nd

extended-status command

external 2nd 3rd external locking protocols 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

external security 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th 87th 88th 89th 90th 91st 92nd 93rd 94th 95th 96th 97th 98th 99th 100th 101st 102nd 103rd 104th 105th 106th 107th 108th 109th 110th 111th 112th 113th 114th 115th 116th 117th 118th 119th 120th 121st 122nd 123rd 124th 125th 126th 127th 128th 129th 130th 131st 132nd 133rd 134th 135th 136th 137th 138th 139th 140th 141st 142nd 143rd 144th 145th 146th 147th 148th 149th 150th 151st 152nd 153rd 154th 155th 156th 157th 158th 159th 160th 161st 162nd 163rd 164th 165th 166th 167th 168th 169th 170th 171st 172nd 173rd 174th 175th 176th 177th 178th

external security configuration example 2nd 3rd 4th 5th

EXTRACT() function