|
|
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
|
|