Index_E

E

ELT() function, 529

ENCODE() function, 562

ENCRYPT() function, 562

encryption of password, 425, 438

entity, 5

entity-relationship model, 242

diagram, 244–245, 252

ENUM column type, 46

environment variables, and security, 416

err attribute (Perl DBI), 617

err method (Perl DBI), 598

errmsg.txt file, 409

error log, 272–273

error messages

"Can't start server: Bind on TCP/ IP port", 464

"Can't start server: Bind on unix socket", 464

ERROR 1044: Access denied for user, 9

ERROR 1064: You have an error in your SQL syntax ..., 10

ERROR 1175: You are in safe update mode..., 56

Failed copying .frm file, 305

"Internal compiler error:", 465

language for displaying, 409

PHP function to return, 576–577

error number, PHP function to
return, 576

errors, in batch mode, 102–103

errstr attribute (Perl DBI), 617

errstr method (Perl DBI), 598

escaped characters, PHP function to return string with, 577, 591

executables for MySQL, 266, 454

execute() method (Java), 629–630

execute method (Perl DBI), 607–608

execute() method (Python), 622

EXECUTE privilege, 435, 488

execute_array method (Perl DBI), 608

executeBatch() method (Java), 630

executemany() method (Python), 622

executeQuery() method (Java), 630

executeUpdate() method (Java), 630

EXIT command, 7

EXP() function, 546–547

experimenting with database, 8–9

EXPLAIN statement, 157–164, 487

with leftmost prefixes, 163–164

to optimize searches, 164–169

exporting data, from Microsoft Access to MySQL, 666

EXPORT_SET() function, 529

EXTRACT() function, 516–517