M

Index
byGareth Downes-Powellet al.
Wrox Press 2003

Mac OSX

installing/configuring PHP on, 25

mall() function, PHP, 304

errors, example e-mailing, 304

manual input symbol, 82

min(expr)/max(~) functions, MySQL, 186

GROUP BY using, 186

Monitor, MySQL, 98

configuring, switches, 99

creating tables, hotel booking system, 100

syntax, commands, 99

multiple Indexes, MySQL, 194

MyCC administration tool, MySQL, 46

connecting to database, 46

displaying tables list/structure, 48

downloading/installing, 46

executing SQL statement, 48

MySQL, 31

as SQL database server, overview, 31

advantages & disadvantages, 32

database, 32

downloading, sources, 33

server, 31

SQL, 32

database tables, configuring, 91

listing/describing tables, 41

databases, 37

creating, CREATE DATABASE, 38

displaying, SHOW DATABASES, 38

overview, examples, 35

using, USE, 38

foreign keys, NOT enforcing, 174

hotel booking system, 91

installation, Windows, 33

winMySQLadmin.exe, functionality, 34

Monitor, 98

MyCC administration tool, 46

functionality, 48

installing & connecting to database, 46

PHPMyAdmin administration tool, 49

functionality, 51

installing & connecting to database, 49

privileges system, configuring, 42

granting privileges, GRANT *, 44

user table privileges, listing, 42

tables, 38

creating, CREATE TABLE, 39

deleting, DROP TABLE, 39

retrieving table definition, DESC, 40