MySQL Cookbook

Index

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

%M format sequence

%m format sequence

magic_quotes_gpc PHP variable

major version numbers

make_checkbox_group( ) method (Ruby)

MAKEDATE( ) function

MAKETIME( ) function

<Manager> element (JDBC)

many-to-many relationships of tables

Mason

master-detail lists

MATCH( ) function 2nd

MAX( ) function 2nd 3rd

     AUTO_INCREMENT values and

     case-sensitivity for

     finding smallest/largest values

     finding values associated with

     IFNULL( ) function and

     subgroups, dividing into

     summarizing with

MAX_FILE_SIZE (PHP)

maxIdleBackup attribute (JDBC Manager element)

maxIdleSwap attribute (JDBC Manager element)

mcb-kjv distribution

mcb.war file

MD5( ) function

     triggers and

mean deviation

mean set of values

MEDIUMBLOB data type 2nd

     images, storing

MEDIUMINT data type

MEDIUMTEXT data type

metacharacters

metadata

     checking existence of databases/table

     default database, determining

     determining whether a statement produced a result set

     ENUM and SET column information, getting

     obtaining the number of rows affected by statements

     query output and

     result set, obtaining

     server, getting

     storage engines, determining

     table column definition, accessing

     table structure information, using in applications

     table, using to validate data

     writing applications that adapt to MySQL server versions

Microsoft Access

Microsoft Excel

Microsoft Windows [See Windows]

MID( ) function 2nd

     fixed-length substrings, sorting by

     variable-length substrings, sorting by

MIN( ) function 2nd

     case-sensitivity for

     finding smallest/largest values

     finding values associated with

     IFNULL( ) function and

     subgroups, dividing into

     summarizing with

minIdleSwap attribute (JDBC Manager element)

minor version numbers

MINUTE( ) function 2nd 3rd

mixed-order sorting

MM-DD-YY format

MM/DD/YY format

MOD( ) function

mod_snake Apache module (Python)

Model-View-Controller (MVC)

modularization

modules [See library files]

modules (Perl)

MONTH( ) function 2nd

MONTHNAME( ) function

multibyte characters

multiple table

multiple-column sorts

multiple-page navigation indexes

multiple-pick forms

multiple-request sessions

multiple-statement transactions

MVC (Mode-View-Controller)

.my.cnf file

my.ini file

my.ini, my.cnf files

my_print_defaults utility

MyISAM tables 2nd

MySQL C client library

mysql program

     copying tables/databases to different servers

     duplicates, removing

     getting parameters from command line

     stopping and starting

     transactions and

     user accounts, setting up

     when not found by command interpreter

mysql prompt

     issuing statements

MySQL Query Browser

MySQL Reference Manual

"MySQL Uncertainty Principle"

mysql-session package (Ruby)

mysql.default_host configuration variables

mysql.default_password configuration variable

mysql.default_port configuration variable

mysql.default_socket configuration variable

mysql.default_user configuration variable

mysql> prompt [See mysql program]

mysql_ functions (PHP)

mysql_default_pw configuration variable

mysql_flags Ruby member name

.mysql_history

mysql_insertid attribute (Perl)

mysql_is_blob attribute

mysql_is_key attribute

mysql_is_num attribute

mysql_is_pri_key attribute

mysql_length Ruby member name

mysql_max_length attribute

mysql_max_length Ruby member name

mysql_sess_destroy( ) function (PHP)

mysql_sess_gc( ) function (PHP)

mysql_sess_read( ) function (PHP)

mysql_sess_write( ) function (PHP)

mysql_table attribute

mysql_thread_id attribute (Perl DBI)

mysql_type attribute

mysql_type Ruby member name

mysql_type_name attribute

mysql_type_name Ruby member name

mysqladmin

     getting parameters from command line

     option files and

mysqld server

MySQLdb database driver module 2nd 3rd

     retrieving sequence values

     special characters and

mysqldump 2nd

     adding elements to ENUM/SET column definitions

     copying tables/databases to different servers

     exporting tables as SQL formatted text

     exporting tables as text files

     option files and

     reading statements from other programs

     table column definitions, accessing 2nd

mysqli_ functions (PHP)

mysqlimport command-line program 2nd

     CSV files, importing

     import

     importing data with

mytags.jar file