Index M

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

Mac OS X
    starting server 
macros
    C API  2nd 
mailing lists
    for installation help 
MAKE_SET() function 
Makefiles
    building client programs  2nd  3rd 
manual server startup (Windows)  2nd 
MASTER CONNECT RETRY option
    replication servers 
MASTER HOST option
    replication servers 
master hosts (replication servers)
    parameters
        changing  2nd 
MASTER LOG FILE option
    replication servers 
MASTER LOG POS option
    replication servers 
MASTER option
    flushing caches 
    resetting cache 
MASTER PASSWORD option
    replication servers 
MASTER PORT option
    replication servers 
MASTER USER option
    replication servers 
master-connect-retry option 
master-detail relationships 
master-retry-count option 
master-slave replication relationship  2nd 
    setting up  2nd  3rd  4th 
MASTER_POS_WAIT() function 
MATCH operator
    full text searches 
MATCH() function  2nd  3rd 
matching order
    for scope columns (grant tables)  2nd 
        privilege problem example  2nd  3rd  4th 
mathematical functions.  [See numeric functions]
mathematical operators.  [See arithmetic operators]
MAX CONNECTIONS PER HOUR option
    granting privileges 
MAX JOIN SIZE option
    setting variables 
MAX QUERIES PER HOUR option
    granting privileges 
MAX ROWS option
    creating tables 
MAX UPDATES PER HOUR option
    granting privileges 
MAX() function 
    generating summaries 
max_allowed_packet variable  2nd  3rd  4th 
max_binlog_cache_size variable 
max_binlog_size server variable 
max_binlog_size variable 
max_connect_errors variable 
max_connections variable  2nd 
max_delayed_threads variable 
max_heap_table_size variable 
max_join_size variable  2nd 
max_sort_length variable 
max_tmp_tables variable 
max_user_connections variable 
max_write_lock_count variable 
maximum table size (data directory)  2nd  3rd 
MD5()
    PHP login authentication 
MD5() function 
MEDIUM option
    error checking tables  2nd 
MEDIUMBLOB string type  2nd 
MEDIUMINT numeric type  2nd 
MEDIUMTEXT string type  2nd 
member common interests example
    Perl DBI API  2nd 
member entry editing example
    Perl DBI API  2nd  3rd  4th  5th  6th  7th 
    PHP API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
member table (U.S. Historical League example) 
    creating  2nd  3rd 
membership renewal example
    Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th 
memory
    increasing for myisamchk utility 
memory management
    C API versus Perl and PHP APIs 
memory usage
    Perl versus PHP 
MERGE tables  2nd 
    creating  2nd 
    in data directory  2nd 
    maximum size 
    portability 
metadata.  [See result set metadata]2nd  [See result set metadata]
methods
    Perl DBI API  2nd  3rd  4th 
        administrative methods  2nd  3rd 
        class methods  2nd  3rd  4th  5th  6th  7th  8th  9th 
        database handle methods  2nd  3rd  4th  5th  6th  7th  8th  9th 
        fetching rows 
        general handle methods  2nd 
        statement handle methods  2nd  3rd  4th  5th  6th  7th 
        utility functions  2nd 
methods.  [See also functions]
Microsoft Access
    MySQL server connections 
MID() function 
MIN ROWS option
    creating tables 
MIN() function 
    generating summaries 
minimum word length (full text searches)
    changing  2nd 
minus sign (-)
    subtraction operator 
MINUTE() function 
mistakes.  [See troubleshooting]
MOD() function 
MODIFY clause
    ALTER TABLE statement  2nd 
MODIFY COLUMN clause
    altering tables 
module interpreters
    versus standalone interpreters  2nd  3rd  4th 
modulo operator (%) 
money
    numeric types for  2nd 
MONTH() function  2nd  3rd 
MONTHNAME() function 
moving.  [See relocating]
mSQL 
multiple servers  2nd  3rd  4th  5th 
    access control to data directory 
    administration duties 
    configuring  2nd 
    mysqld_multi script  2nd 
    on Windows  2nd  3rd 
    option files for  2nd  3rd 
    passwords
        setting  2nd 
    startup options  2nd 
multiple tables
    deleting and updating records  2nd  3rd 
    retrieving records from  2nd  3rd  4th  5th  6th  7th  8th  9th 
    retrieving records from.  [See joins]2nd  [See unions]
multiplication operator (*) 
my keyword
    Perl DBI API 
my_bool data type
    C API 
my_getopt.h header file 
my_global.h header file 
my_print_defaults utility 
my_ulonglong data type
    C API  2nd 
MyISAM tables  2nd 
    AUTO_INCREMENT attribute  2nd  3rd  4th 
    converting to  2nd 
    in data directory 
    maximum size 
    portability 
myisam_block_size variable 
myisam_bulk_insert_tree_size variable 
myisam_max_extra_sort_file_size variable 
myisam_max_sort_file_size variable 
myisam_recover_options variable 
myisam_sort_buffer_size variable 
myisamchk utility  2nd  3rd  4th  5th  6th 
    options
        list of  2nd  3rd  4th  5th  6th 
        standard options supported 
    repairing tables  2nd  3rd  4th  5th  6th  7th 
    resorting indexes 
    scheduling preventive maintenance  2nd 
    variables
        list of  2nd  3rd 
    versus isamchk utility  2nd 
myisampack utility  2nd  3rd  4th 
    options
        list of  2nd 
        standard options supported 
MyODBC 
    installation on Windows  2nd  3rd 
MySQL
    advantages of  2nd  3rd  4th  5th  6th  7th 
    client/server architecture of  2nd  3rd 
    downgrading 
    installation on UNIX  2nd  3rd  4th  5th  6th 
        Apache and PHP installation  2nd  3rd 
        binary distributions  2nd 
        data directory and grant table initialization  2nd 
        login account creation  2nd 
        Perl DBI support  2nd  3rd 
        RPM distributions  2nd  3rd 
        server startup  2nd 
        source distributions  2nd  3rd 
    installation on Windows  2nd  3rd  4th 
        Apache and PHP installation 
        MyODBC installation  2nd  3rd 
        Perl DBI support  2nd 
    integration with other applications  2nd 
    obtaining for installation  2nd  3rd 
    pronunciation of 
    unsupported features  2nd 
    upgrading  2nd 
        mysqld_safe script  2nd 
    versus mysql 
mysql
    versus MySQL 
MySQL
    web integration of  2nd  3rd  4th  [See also PHP API]
MySQL 4.1
    converting tables to  2nd  3rd 
MySQL accounts.  [See accounts]
mysql client 
mysql command
    password prompts 
    prompt
        changing  2nd 
    queries  2nd  3rd  4th  5th 
        batch mode  2nd  3rd 
        canceling 
        copying and pasting  2nd 
        input line editing  2nd  3rd 
        reading from file 
        semicolon in  2nd 
        vertical output display 
    sample database creation  2nd  3rd 
    server connections  2nd  3rd  4th 
MySQL data directory.  [See data directory]
MYSQL data type
    C API  2nd 
mysql database
    grant tables
        securing  2nd  3rd  4th  5th  6th  7th  8th 
        securing.  [See grant tables, securing]
    privileges for
        avoiding risks 
mysql program  2nd  3rd  4th 
    commands
        list of  2nd  3rd 
    options
        list of  2nd  3rd  4th  5th 
        standard options supported 
    prompt definition escape sequences
        list of  2nd 
    variables
        list of  2nd 
MySQL programs.  [See programming MySQL]
MySQL query optimizer  2nd 
    overriding  2nd 
    tips for using  2nd  3rd  4th 
mysql utility 
mysql-log-rotate script 
mysql.h header file 
mysql.server script  2nd  3rd 
    option groups used 
    UNIX error log 
mysql_affected_rows()  2nd 
    C result set processing  2nd 
    PHP result set processing  2nd 
    processing PHP query results 
mysql_change_user()
    C connection management  2nd 
    PHP connection management  2nd 
mysql_character_set_name()
    C information gathering 
    PHP information gathering 
mysql_close()
    C connection management  2nd 
    PHP connection management  2nd 
    server connections 
mysql_config utility  2nd  3rd 
    C API  2nd 
    compiling and linking client programs 
    options
        list of  2nd 
mysql_connect()
    C deprecated function 
    PHP connection management  2nd  3rd 
    PHP server connections  2nd  3rd  4th 
    versus mysql_pconnect() 
mysql_convert_table_format utility 
mysql_create_db()
    C deprecated function 
    PHP deprecated function 
mysql_data_  [See k()]
    C result set processing  [See k()]2nd  [See k()]
    PHP result set processing  [See k()]2nd  [See k()]
mysql_db_name()
    PHP result set processing  2nd 
mysql_db_query()
    PHP deprecated function 
MYSQL_DEBUG environment variable 
mysql_debug()
    C debugging 
mysql_drop_db()
    C deprecated function 
    PHP deprecated function 
mysql_dump_debug_info()
    C debugging 
mysql_eof()
    C deprecated function 
mysql_errno
    Perl DBI API 
mysql_errno() 
    C error handling 
    PHP error handling  2nd  3rd  4th  5th 
mysql_error
    Perl DBI API 
mysql_error() 
    C error handling 
    PHP error handling  2nd  3rd  4th  5th 
mysql_escape_string()  2nd 
    C deprecated function 
    escaping quotation marks in PHP 
    PHP queries  2nd 
mysql_fetch_array()
    PHP query processing  2nd  3rd 
    PHP result set processing  2nd  3rd 
mysql_fetch_assoc()
    PHP query processing  2nd  3rd 
    PHP result set processing  2nd 
mysql_fetch_field()
    C result set processing  2nd 
    PHP result set processing  2nd  3rd  4th 
mysql_fetch_field_direct()
    C result set processing  2nd 
mysql_fetch_fields()
    C result set processing  2nd 
mysql_fetch_lengths()
    C result set processing  2nd 
    PHP result set processing  2nd 
mysql_fetch_object()
    PHP query processing  2nd  3rd 
    PHP result set processing  2nd 
mysql_fetch_row() 
    C result set processing  2nd 
    PHP query processing  2nd  3rd  4th 
    PHP result set processing  2nd 
    PHP server queries 
MYSQL_FIELD data type
    C API  2nd  3rd  4th  5th  6th  7th 
mysql_field_
    C result set processing  [See k()]2nd  [See k()]
    PHP result set processing  [See k()]2nd  [See k()]
mysql_field_count()
    C result set processing  2nd  3rd 
    converting to mysql_num_fields() 
mysql_field_flags()
    PHP result set processing  2nd  3rd 
mysql_field_len()
    PHP result set processing  2nd 
mysql_field_name()
    PHP result set processing  2nd 
MYSQL_FIELD_OFFSET data type
    C API 
mysql_field_table()
    PHP result set processing  2nd 
mysql_field_tell()
    C result set processing 
mysql_field_type()
    PHP result set processing  2nd 
mysql_find_rows utility 
mysql_fix_privilege_tables script  2nd 
mysql_free-result() 
mysql_free_result()
    C result set processing  2nd 
    PHP query processing 
    PHP result set processing  2nd 
    PHP server queries 
mysql_get_client_info()
    C information gathering 
    PHP information gathering 
mysql_get_host_info()
    C information gathering 
    PHP information gathering 
mysql_get_proto_info()
    C information gathering 
    PHP information gathering 
mysql_get_server_info()
    C information gathering 
    PHP information gathering 
MYSQL_HISTFILE environment variable 
MYSQL_HOST environment variable 
mysql_hostinfo
    Perl DBI API 
mysql_info
    Perl DBI API 
mysql_info()
    C information gathering  2nd 
    PHP information gathering 
mysql_init()
    C connection management  2nd 
    error checking 
    server connections 
mysql_insert_id()
    C result set processing  2nd 
    PHP result set processing  2nd 
mysql_insertid
    Perl DBI API 
mysql_insertid()
    Perl DBI API 
mysql_install_db script  2nd  3rd 
    initializing user table 
    options
        list of  2nd 
mysql_is_auto_increment()
    Perl DBI API 
mysql_is_blob()
    Perl DBI API 
mysql_is_key()
    Perl DBI API 
mysql_is_num()
    Perl DBI API 
mysql_is_pri_key()
    Perl DBI API 
mysql_kill()
    C deprecated function 
mysql_length()
    Perl DBI API 
mysql_list_dbs()
    C deprecated function 
    PHP queries  2nd 
mysql_list_fields()
    C deprecated function 
    PHP queries  2nd 
mysql_list_processes()
    C deprecated function 
    PHP queries  2nd 
mysql_list_tables()
    C deprecated function 
    PHP queries  2nd 
mysql_max_length attribute
    Perl DBI result set metadata  2nd 
mysql_max_length()
    Perl DBI API 
mysql_num_fields() 
    C result set processing  2nd 
    converting mysql_field_count() to 
    PHP query processing 
    PHP result set processing  2nd 
    processing PHP query results 
mysql_num_rows()
    C result set processing  2nd 
    PHP query processing 
    PHP result set processing 
    processing PHP query results 
mysql_options()
    C connection management  2nd  3rd  4th  5th 
mysql_pconnect()
    PHP connection management  2nd 
    versus mysql_connect() 
mysql_ping()
    C connection management 
    PHP connection management 
mysql_protoinfo
    Perl DBI API 
MYSQL_PS1 environment variable 
MYSQL_PWD environment variable 
mysql_query()  2nd 
    C queries  2nd 
    PHP queries  2nd 
    PHP server queries 
    processing PHP query results  2nd  3rd  4th 
        with result set  2nd  3rd  4th  5th  6th 
        without result set  2nd 
mysql_read_default_file option
    Perl DBI connection parameters  2nd  3rd  4th 
mysql_read_default_group option
    Perl DBI connection parameters  2nd 
mysql_real_connect()
    C connection management  2nd  3rd  4th  5th 
    error checking 
    server connections  2nd 
mysql_real_escape_string()  2nd  3rd 
    C queries  2nd  3rd 
    escaping quotation marks in PHP 
    PHP queries  2nd 
mysql_real_query()  2nd 
    C queries  2nd 
mysql_refresh()
    C deprecated function  2nd  3rd 
mysql_reload()
    C deprecated function 
MYSQL_RES data type
    C API  2nd 
mysql_result()
    PHP result set processing  2nd 
MYSQL_ROW data type
    C API  2nd 
mysql_row_
    C result set processing  [See k()]2nd  [See k()]
MYSQL_ROW_OFFSET data type
    C API 
mysql_row_tell()
    C result set processing  2nd 
mysql_select_db()
    C queries  2nd 
    PHP database selections 
    PHP queries  2nd 
mysql_server_end()
    C embedded server communication 
mysql_server_init()
    C embedded server communication  2nd 
mysql_serverinfo
    Perl DBI API 
mysql_setpermission script 
mysql_shutdow()
    C administrative function 
mysql_ssl_set() 
    C connection management  2nd 
mysql_stat
    Perl DBI API 
mysql_stat()
    C information gathering  2nd 
    PHP information gathering 
mysql_store_result() 
    C result set processing  2nd 
    Perl DBI API 
    versus mysql_use_result()  2nd  3rd  4th 
mysql_table()
    Perl DBI API 
mysql_tablename()
    PHP result set processing  2nd 
MYSQL_TCP_PORT environment variable 
mysql_thread_end()
    C threaded clients 
mysql_thread_id
    Perl DBI API  2nd 
mysql_thread_id()
    C information gathering  2nd 
    PHP information gathering 
mysql_thread_init()
    C threaded clients 
mysql_thread_safe()
    C threaded clients 
mysql_type()
    Perl DBI API 
mysql_type_name()
    Perl DBI API 
mysql_unbuffered_query()
    PHP queries  2nd 
MYSQL_UNIX_PORT environment variable 
mysql_use_result() 
    C result set processing  2nd 
    Perl DBI API  2nd 
    versus mysql_store_result()  2nd  3rd  4th 
mysqlaccess script  2nd  3rd  4th 
    options
        list of  2nd 
        standard options supported 
mysqladmin client 
mysqladmin program
    passwords
        setting 
    reloading grant tables 
mysqladmin utility  2nd  3rd  4th 
    commands
        list of  2nd  3rd 
    options
        list of  2nd 
        standard options supported 
    server shutdown 
    variables
        list of  2nd 
mysqladmin variables command
    data directory location 
mysqladmin_reload command 
mysqlbinlog utility  2nd  3rd  4th 
    options
        list of  2nd 
        standard options supported 
mysqlbug script  2nd  3rd 
mysqlc program  2nd 
mysqlcheck utility  2nd  3rd  4th  5th  6th 
    options
        list of  2nd  3rd  4th  5th 
        standard options supported 
    scheduling preventive maintenance  2nd 
mysqld server  2nd  3rd  4th  5th  6th 
    option groups used 
    options
        BDB options, list of  2nd 
        InnoDB options, list of  2nd 
        list of  2nd  3rd  4th  5th  6th  7th  8th 
        replication options, list of  2nd  3rd  4th 
        standards options supported  2nd 
        Windows options, list of  2nd 
    starting directly 
    variables  2nd 
mysqld.server script
    starting server with 
mysqld_multi 
mysqld_multi script  2nd  3rd  4th  5th 
    options
        list of  2nd 
        standard options supported 
mysqld_safe 
mysqld_safe script  2nd 
    option groups used 
    options
        list of  2nd 
    starting server with 
    timezone
        setting  2nd 
    UNIX error log 
    upgrading tips  2nd 
mysqldump client 
mysqldump program  2nd 
    advantages and disadvantages  2nd 
    options
        data format options, list of  2nd 
        list of  2nd  3rd  4th  5th  6th 
        standard options supported 
    variables
        list of  2nd 
mysqldump utility  2nd  3rd  4th 
    backing up databases  2nd  3rd  4th 
    copying databases 
mysqldumpslow utility  2nd 
mysqlhotcopy script
    backing up databases  2nd 
mysqlhotcopy utility  2nd  3rd  4th 
    options
        list of  2nd  3rd 
        standard options supported 
mysqlimport utility  2nd  3rd  4th  5th 
    options
        data format options, list of  2nd 
        list of  2nd 
        standard options supported 
Mysqlperl module 
mysqlshow command  2nd 
mysqlshow utility  2nd  3rd  4th  5th 
    options
        list of 
        standard options supported