M
Mastery Checks, answers to, 313324
mathematical functions, 149154
MDI (Multiple Document Interface) mode, 224227
MEDIUMINT data type, 5556
MEDIUMINT integer type, 4142
memory
changing settings, 2324
HEAP tables, 57
query cache, 203
reallocating, 2324
status of, 210
usage of, 201
Memory Health settings, 210
minutes, display of, 4851
Multiple Document Interface (MDI) mode, 224227
my.ini file, 11, 1415, 17, 2324
MyISAM parameters, 201202
myisam-recover option, 306307
MyISAM table type, 5657, 60
MyISAM tables, 5657, 5960
MyODBC
downloading, 19
installing, 1922
Linux systems, 2528
Windows systems, 9
MySQL
changing settings, 2324
choosing environment for, 58
command line, 2835
command line vs. GUI, 2829
command prompt, Linux, 3235
command prompt, Windows, 2932
default settings, 9, 1519, 23
displaying data in, 345351
documentation for, 3637
downloads, 10, 3536
Health information, 209211
inserting data in, 345351
licensing approach, 5
mailing lists, 37
open source and, 35
PHP and, 330
reserved words, 54, 325327
resources for, 3537
speed considerations, 7
startup variables , 200205
support/consulting, 37
system checks, 17
terminology, 23
using PHP with, 242265
version, 16
MySQL Administrator, 192222
command line, 197
configuration options, 198200
connections, 194197
edit options, 193
file options, 193
Help, 194, 197
installing on Linux, 221222
installing on Windows, 217221
overview, 192193
password options, 204
security options, 204
setting options, 194197
starting/stopping services, 198
startup variables, 200205
tools, 194, 197
user administration, 205207
user interface, 193194
view options, 193
viewing information in, 197216
MySQL Control Center. See MySQLCC
MySQL Reference Manual, 3637
MySQL Server, 2, 210, 279. See also servers
MySQL service
communication with, 3
restarting, 16
shutting down, 16
starting, 1314, 16
MySQLCC (MySQL Control Center), 222239
Console Manager, 224234
installing on Linux systems, 239240
installing on Windows, 234239
overview, 222223
settings, 223224
mysql_connect function (), 245247
mysql_errno () function, 256257
mysql_error () function, 256257
mysql_escape_string () function, 262
mysql_fetch functions, 250254
mysql_list_dbs () command, 247248
mysql_list_tables () command, 248
mysql_pconnect () function, 245247
mysql_query () command, 249250
mysql_quote () function, 261
mysql_select_db () function, 249
mysql_unbuffered_query () function, 250