Specifications

mysql_select_db() function
841
databases
creating, 187
creating from PHP
scripts, 242
deleting, 242
results.php script,
230-231
selecting, 193-194
tables, creating,
194-199
viewing, 198-199
Web database
architecture, 228-231
date and time
converting between
PHP and MySQL for-
mats, 396-398
DATE_FORMAT()
function, 396-397
MySQL Web site, 400
UNIX_TIMESTAMP
function, 397-398
errors, 482-484
GRANT command,
188-189, 192-193
identifiers, 199-200
installing, 783
UNIX environment,
783-787
Windows environment,
793
join types, 219
logging in to, 185-187
logging out of, 193
max_connections parame-
ter, 235
mod_auth_mysql module,
322-324
documentation Web
sites, 324
installing, 322-323
mysql command, 186
privileges, 188-193
global privileges, 189
GRANT command,
188-189, 192-193
principle of least
privilege, 188
REVOKE command,
192-193
types, 190-191
resources, 806
REVOKE command,
192-193
semicolons (;), 185
syntax, extended, 222
users
GRANT command,
188-189, 192-193
REVOKE command,
192-193
setting up, 187-188,
192-193
Web site, 185
mysql command, 186
mysql connect() function,
482
mysql database, 246
columns_priv table, 250
db table, 248-249
host table, 249
tables_priv table, 250
user tables, 247
MySQL database
connection verification,
250
request verification, 251
mysql errno() function,
483
mysql error() function,
483
MySQL online manual
Web site, 206
mysql pconnect()
function, 483
mysql query() function,
483
mysql select db()
function, 483
MySQL Web site, 226,
263, 322, 784, 795, 802,
806
date and time functions,
400
online manual Web site,
206
mysqladmin facility, 199
mysql_affected_rows()
function, 241
mysql_close() function,
234
mysql_connect() function,
234
mysql_db_query()
function, 236
mysql_fetch_array()
function, 236-237
mysql_fetch_row()
function, 237
mysql_free_result()
function, 241-242
mysql_numrows()
function, 236
mysql_pconnect()
function, 234
mysql_query() function,
235-236
mysql_result() function,
237
mysql_select_db()
function, 235
40 7842 index 3/6/01 4:22 PM Page 841