MySQL: Essential Skills

M

mailing lists, 37

Mastery Checks, answers to, 313324

mathematical functions, 149154

MAX function, 148

MaxDB database, 35

Maxdb mode, 49

MDI (Multiple Document Interface) mode, 224227

MEDIUMBLOB data type, 47

MEDIUMINT data type, 5556

MEDIUMINT integer type, 4142

MEDIUMTEXT data type, 47

memory

changing settings, 2324

HEAP tables, 57

query cache, 203

reallocating, 2324

status of, 210

usage of, 201

Memory Health settings, 210

menus , drop-down, 51

MERGE table type, 56, 60

MERGE tables, 56, 5961

Microsoft Access, 273275

Microsoft Excel, 271273

Microsoft systems, 8

MID function, 163164

MIN function, 148

minutes, display of, 4851

MOD function, 151152

MODIFY option, 91

months, display of, 4851

Multiple Document Interface (MDI) mode, 224227

my.cdf file, 11, 1415

my.cnf file, 2324

.MYD file, 110

.MYI tile, 110

my.ini file, 11, 1415, 17, 2324

my.ini Setup tab, 17

MyISAM parameters, 201202

myisam-recover option, 306307

MyISAM table type, 5657, 60

MyISAM tables, 5657, 5960

myisamchk script, 303305

MyODBC

downloading, 19

installing, 1922

Linux systems, 2528

Windows systems, 9

MyODBC drivers, 1922

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 AB, 2, 45

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 Client, 3, 280281

MySQL Control Center. See MySQLCC

mysql database, 3

MySQL drivers, 814

MySQL home page, 3537

MySQL partners , 37

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

MySQL web site, 5

mysqlbinlog script, 302

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

mysqldump script, 296298

mysql_errno () function, 256257

mysql_error () function, 256257

mysql_escape_string () function, 262

mysql_fetch functions, 250254

mysqlhotcopy script, 295

mysqli functions, 263

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