Specifications

databases
819
in a particular order,
219-220
with specific criteria,
212, 214
rows, returning, 222-223
sensitive data
credit card numbers,
storing, 338
storing, 336-337
tables
aliases, 218-219
joining, 216-217
rows unmatched, 217-
218
two-table joins,
214-216
Data Encryption Standard
(DES), 295
data storage, files.
See files
data types, 22
BLOB types (binary large
objects), 204-205
date and time data types,
203
ENUM type, 205
floating point data types
(numeric column types),
201-202
integral data types
(numeric column types),
201
regular string data types,
204
SET type, 205
TEXT types, 204-205
database schema
(PHPBookmark
application), 502
front page, 504-506
database servers, Web
database architecture,
181
DatabaseCentral.com
Web site, 806
databases, 172-175
advantages, 67
Book-O-Rama
setting up, 208
tables, SQL code, 210
book_sc database
(Shopping Cart applica-
tion), 546-548
columns, DESCRIBE
statement, 257
content management
systems, 590
create database.sql,
597-598
creating
from PHP scripts, 242
with MySQL, 187
data
aggregating, 220-222
grouping, 220-222
inserting, 209-211
joins, 219
loading from files, 263
retrieving, 211-212
retrieving from multiple
tables, 214-219
retrieving in a particu-
lar order, 219-220
retrieving with specific
criteria, 212-214
rows unmatched,
217-218
tables, aliases, 218-219
tables, joining, 216-217
two-table joins,
214-216
deleting, 242
dropping, 226
information
gathering, 254
SHOW statement,
254-257
keys, 173-175
foreign keys, 175
lists, 657
mysql, 246
columns_priv table, 250
db table, 248-249
host table, 249
tables_priv table, 250
user table, 247
MySQL
aggregate functions,
221
connection verification,
250
join types, 219
request verification,
251
MySQL databases
creating from PHP
scripts, 242
deleting, 242
results.php script,
230-231
Web database architec-
ture, 228-231
optimizing, 261-262
default values, 262
designs, 261
indexes, 262
permissions, 261
persistent connections,
262
tables, 261-262
passwords
encrypting, 252
encrypting (authentica-
tion), 310-311
storing, 252
storing (authentica-
tion), 308-310
poll, code to set up,
420-421
40 7842 index 3/6/01 4:22 PM Page 819