Index

M

manipulating strings

see string manipulation.

many-to-many relationship, 24

foreign keys, 25

illustrated, 25

junction tables, 24

ProductCatalog database, 393

mapping table

see junction tables.

MAX function, 89

mediumblob data type, 535

mediumint data type, 536

mediumtext data type, 535

Microsoft MSDN web site, 137

MID function, 120, 125

MIN function, 89

MINUS operator, 164, 165

MODE keyword, 469

modifying data

deleting data (see DELETE statement).

inserting data (see INSERT statement).

updating data (see UPDATE statement).

modifying rows

see UPDATE statement.

modulus operator, 108

money data types, 113, 399

Access, 537

currency data types, 531

SQL Server, 532

multi-row INSERT, 73

multiple columns

retrieving, 34

MyISAM table type, 283

ProductCatalog database, 397

MySQL tools

executing SQL statements, 507

web site reference, 329