Index_M

M

main function

for aggregate user-defined functions, 201

for standard user-defined functions, 197–198

maintenance phase of database lifecycle, 249–250

example, 255–256

make command, 459, 465

MAKE_SET() function, 536

mandatory relationship, 214, 243, 243

many-to-many relationship, 213, 213, 243, 243

conversion to two one-to-many relationships, 244

master for replication, 337

commands for, 343

configuration file options, 340

MASTER_POS_WAIT() function, 566–567

MATCH() function, for full-text search, 133

MAX() function, 20–21, 556

index use for, 153

max_allowed packet variable, 383

max_binlog_cache_size variable, 384

max_binlog_size variable, 384

max_connect_errors variable, 384

max_connections variable, 368–373, 384

MAX_CONNECTIONS_PER_HOUR, 444

max_delayed_threads variable, 384

max_heap_table_size variable, 384

max_join_size variable, 384

MAX_JOIN_SIZE variable, 392, 496

MAX_QUERIES_PER_HOUR, 444, 445

max_sort_length variable, 384

max_tmp_tables variable, 384

MAX_UPDATES_PER_HOUR, 445

max_used_connections variable, 369, 389

max_user_connections variable, 384, 444

max_write_lock_count variable, 384

MD5() function, 567

MEDIUMBLOB column type, 46

MEDIUMINT column type, 43

MEDIUMTEXT column type, 46

memory

for HEAP tables, 63

and performance, 393

PHP function to free, 584–585

MERGE tables, and indexes, 152

message parameter, of user-defined init function, 197

metaphone, 194

Microsoft Access, exporting data to MySQL, 666

MIN() function, 22, 556–557

index use for, 153

MINUTE() function, 518

mirroring, 469, 470, 470

MOD() function, 550

modeling, 187

MODIFY clause, of ALTER TABLE statement, 26

MONTH() function, 29, 518

MONTHNAME() function, 519

moveToCurrentRow() method (Java), 637

moveToInsertRow() method (Java), 637

multicolumn indexes, auto increment field and, 150–151

multivalued dependencies, 234

my-huge.cnf file, 271, 366

my-large.cnf file, 271, 366

my-medium.cnf file, 271, 366

my-small.cnf file, 271, 366

my.cnf file, 269, 416

.MYD file extension, 57, 263

.MYI file extension, 152, 263

MyISAM table backups

with BACKUP command, 302– 305

by direct copying files, 307–309

restoring, 305–307

MyISAM table type, 56–60

compressed tables, 58–60

dynamic tables, 57–58

and indexes, 152

static tables, 57

myisam_bulk_insert_tree_size variable, 384

myisamchk utility

analyzing tables with, 283–284

checking tables with, 287–288

optimizing tables with, 281–282

repairing tables with, 291–292

using, 294–298

check options, 296–297

general options, 295–296, 298

repair options, 297–298

myisam_max_extra_sort_file_size variable, 385

myisam_max_sort_file_size variable, 385

myisampack utility, 58–60, 262

myisam_recover_options variable, 385

myisam_sort_buffer_size variable, 385

MyODBC

functions, 672–690

driver, 663

MySQL

basics, 4–5

configuration, 269–272

precedence of files, 269–270

sample files, 271, 366

executable files, 454

exporting data from Microsoft Access to, 666

logging, 272–279

binary update log, 273–276

error log, 272–273

query log, 273

rotating logs, 277–279

slow query log, 276–277

running in ANSI mode, 408

starting and shutting down

executables, 266

in Unix, 263–265

in Windows, 265–269

user-defined functions, 191–204

using different languages in, 408–413

character set, 409–413

error message display, 409

mysql command, options, 52–56

MYSQL data type (C), 645

mysql database, 416–445

permission tables, 417

columns_priv table fields, 419–420

db table fields, 418

func table fields, 420

GRANT and REVOKE to manipulate, 428–438

host table fields, 419

order of precedence, 422

populating, 422–440

tables_priv table fields, 419

user table fields, 417–418

MySQL server

changing variable values while running, 391–393

connecting to, 5–7

as root, 7

disconnecting from, 7

managing multiple, 461–464

PHP function to return status, 592

PHP function to return version, 585

programming, work division between server and application, 181–185

mysqladmin utility, 261, 361

to locate data directory, 262

processlist output, 369–373

to set passwords, 438

mysql_affected_rows() function (C), 648

mysql_affected_rows() function (PHP), 572

mysqlbinlog utility, 275, 331

mysql_change_user() function (C), 648

mysql_change_user() function (PHP), 572–573

mysql_character_set_name() function (C), 648

mysqlcheck utility, 262

analyzing tables with, 283

checking tables with, 286–287

optimizing tables with, 281

repairing tables with, 290–291

using, 292–294

mysql_client_encoding() function (PHP), 573

mysql_close() function (C), 648

mysql_close() function (PHP), 573

mysql_connect() function (C), 648

mysql_connect() function (PHP), 573–574

mysql_create_db() function (C), 648

mysql_create_db() function (PHP), 574

mysqld (server), 261, 454

options, 374–378

mysql_data_seek() function (C), 648

mysql_data_seek() function (PHP), 574–575

mysql_db_name() function (PHP), 575

mysql_db_query() function (PHP), 575

mysql_debug() function (C), 648

mysql_drop_db() function (C), 650

mysql_drop_db() function (PHP), 575–576

mysqld_safe script, 263

mysqldump, 261

for backups, 309–315

restoring database backed up with, 311–315

mysql_dump_debug_info() function (C), 650

mysqldumpslow utility, 277

mysql_eof() function (C), 650

mysql.err log, 272

mysql_errno() function (C), 650

mysql_errno() function (PHP), 576

mysql_error() function (C), 650

mysql_error() function (PHP), 576– 577

mysql_escape_string() function (C), 650

mysql_escape_string() function (PHP), 577

mysql_fetch_array() function (PHP), 577–578

mysql_fetch_assoc() function (PHP), 578

mysql_fetch_field() function (C), 651

mysql_fetch_field() function (PHP), 579

mysql_fetch_field_direct() function (C), 651

mysql_fetch_fields() function (C), 651

mysql_fetch_lengths() function (C), 651–652

mysql_fetch_lengths() function (PHP), 580

mysql_fetch_object() function (PHP), 580–581

mysql_fetch_row() function (C), 652

mysql_fetch_row() function (PHP), 581

MYSQL_FIELD data type (C), 645–647

mysql_field_count() function (C), 652

mysql_field_flags() function (PHP), 581–582

mysql_field_len() function (PHP), 582

mysql_field_name() function (PHP), 582–583

MYSQL_FIELD_OFFSET data type (C), 648

mysql_field_seek() function (C), 652

mysql_field_seek() function (PHP), 583

mysql_field_table() function (PHP), 583–584

mysql_field_tell() function (C), 653

mysql_field_type() function (PHP), 584

mysql_free_result() function (C), 653

mysql_free_result() function (PHP), 584–585

mysql_get_client_info() function (C), 653

mysql_get_client_info() function (PHP), 585

mysql_get_host_info() function (C), 653

mysql_get_host_info() function (PHP), 585

mysql_get_proto_info() function (C), 653

mysql_get_proto_info() function (PHP), 585

mysql_get_server_info() function (C), 653

mysql_get_server_info() function (PHP), 585

mysqlhotcopy utility, 262

for backups, 327–328

mysqlimport utility, 262

to restore backups from SELECT INTO, 325–326

mysql_info() function (C), 654

mysql_info() function (PHP), 586

mysql_init() function (C), 654

mysql_insert_id() function (C), 654

mysql_insert_id() function (PHP), 586

mysql_kill() function (C), 654

mysql_list_dbs() function (C), 654–655

mysql_list_dbs() function (PHP), 586–587

mysql_list_fields() function (C), 655

mysql_list_fields() function (PHP), 587

mysql_list_processes() function (C), 655

mysql_list_processes() function (PHP), 587–588

mysql_list_tables() function (C), 655–656

mysql_list_tables() function (PHP), 588

mysql_multi utility, 461–464

mysql_num_fields() function (C), 656

mysql_num_fields() function (PHP), 588–589

mysql_num_rows() function (C), 656

mysql_num_rows() function (PHP), 589

mysql_options() function (C), 656–657

mysql_pconnect() function (PHP), 176, 589–590

mysql_ping() function (C), 657

mysql_ping() function (PHP), 590

MYSQL_PWD variable, 416

mysql_query() function (C), 657

mysql_query() function (PHP), 590–591

mysql_real_connect() function (C), 657–658

mysql_real_escape_string() function (C), 658–659

mysql_real_escape_string() function (PHP), 591

mysql_real_query() function (C), 659

mysql_reload() function (C), 659

MYSQL_RES data type (C), 648

mysql_result() function (PHP), 591–592

MYSQL_ROW data type (C), 648

mysql_row_seek() function (C), 659

mysql_row_tell() function (C), 659–660

mysql_select_db() function (C), 660

mysql_select_db() function (PHP), 592

mysql.server script, 264

mysql_shutdown() function (C), 660

mysql_stat() function (C), 660

mysql_stat() function (PHP), 592

mysql_store_result() function (C), 660–661

mysql_tablename() function (PHP), 592–593

mysql_thread_id() function (C), 661

mysql_thread_id() function (PHP), 593

mysql_unbuffered_query() function (PHP), 593

mysql_use_result() function (C), 661

my_ulongong data type (C), 645



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net