Specifications

syntax
860
MODIFY [COLUMN]
column_description, 224
RENAME [AS]
new_table_name, 224
SHOW statement, 255-257
syntax errors, 478-480
syntax highlighter,
454-455
syntaxes, ALTER TABLE
statement, 224
system capacity limits
(commercial Web sites),
279
system requirements,
user personalization,
498
system() function, 366
systems, database secu-
rity, 246, 252. See also
privilege system
SYSTRAN Web site, 804
t1lib, downloading, 402
T
tab control sequence (\t),
58
tables
aliases, 218-219
altering, 223-225
BDB, 263
Book-O-Rama database
(SQL code), 210
Cartesian product, 215
column types, 196-198
columns, 173
atomic column values,
178
DESCRIBE statement,
257
columns_priv, 247-250
mysql database, 250
creating in MySQL,
194-199
keywords, 196
viewing tables, 198-199
data, retrieving, 214-219
database optimization,
261-262
db, 247-249
mysql database,
248-249
dropping, 226
equi-joins, 215
grant, 247-251
HEAP, 262
host, 247-249
mysql database, 249
joining, 216-217
joins, 214, 219
keys, 173-175
creating for Web
databases, 179
left joins, 217-218
MyISAM, 262
rows, 173
returning, 222-223
unmatched, 217-218
values, 173
schemas, 175
scope fields, 248
tables_priv, 247-250
mysql database, 250
two-table joins, 214-216
types, 262-263
user, 247-248
mysql database, 247
tables (databases), 173
types, 180
tables_priv table, 247-250
mysql database, 250
tags
HTML tags, meta tags,
160
<IMG SRC>, 594
PHP tags, 14-15
ASP style, 15
require() statement, 121
SCRIPT style, 15
short style, 15
XML style, 15
TCP (Transmission Control
Protocol), 333
TCP/IP networks, security,
284
templates, Web site tem-
plates (require() state-
ment), 121-126
terminating execution
(scripts), 450
ternary operator, 32
testing
code, 474-475
GPG (Gnu Privacy Guard),
342-347
PHP
support, 791
Windows environment,
800
SSL, 792-793
string length, 105
variable status, 37
text
anti-aliasing, 408
buttons, colors and fonts,
411
ciphertext (encryption),
293
fitting onto buttons,
415-418
images
creating, 410-419
drawing or printing on,
406-408
40 7842 index 3/6/01 4:22 PM Page 860