|
|
wait_timeout variable, 176, 387
Warn attribute (Perl DBI), 613
wasNull() method (Java), 639
weak entity, 244
WEEK() function, 522–523
WEEKDAY() function, 523
WHERE clause
in SELECT statement, 14
index use to match condition, 153
setting variable, 101
Widenius, Michael, 3
width specification, for numeric column type, 45
wildcard (%), LIKE clause with, 74–75
wildcard (*), in SELECT statement, 14
wildcard (_), LIKE comparison operator with, 74–75
wildcard permissions, 439–440
Windows
avoiding common problems, 466
BACKUP statement in, 304–305
connecting to MySQL server from, 6
data source setup, 664
installing MySQL on, 453–455
precedence of configuration files, 269–270
RESTORE TABLE statement in, 306
starting and shutting down MySQL in, 265–269
avoiding common problems, 268–269
startup configuration file, 269, 270–271
symlink for database on, 475
Windows 95/98/Me, shortcut to start MySQL automatically, 266
Windows NT/2000/XP, installing MySQL as service, 267, 268
winmysqladmin, 267
WITH GRANT OPTION, 443
write locks
for tables, 118
priority, 120–121
|
|