|
|
UCASE() function, 543
UDF. See user-defined functions
unbuffered query, PHP function to return results, 593
UNION statement, 92–94, 497
unique fields, 23–24
unique index
auto increment field for, 142
creating, 140–141
unit testing, 189
Unix
BACKUP statement in, 302–304
connecting to MySQL server from, 6
data source setup, 664
installing binary distribution
rpm, 458
tar, 455–457
precedence of configuration files, 269
RESTORE TABLE statement in, 306
starting and shutting down MySQL in, 263–265
startup configuration file, 269
Unix sockets, for client access to server, 263
UNIX_TIMESTAMP() function, 522
UNLOCK TABLES statement, 118–120, 498
unpacking files, for source code installation, 459
update log, 272
UPDATE privilege, 436, 489
UPDATE statement, 24, 498
optimizing, 171
updateRow() method (Java), 639
updateXXX() method (Java), 638–639
upgrading MySQL, from version 3 to 4, 466–468
UPPER() function, 543
Uptime status value, 391
USAGE privilege, 436, 489
USE statement, 9, 498
user-defined functions, 191–204
aggregate, 191, 200–201
sample, 201–204
compiling and installing samples with MySQL, 192–194
standard, 195–198
creating, 198–200
troubleshooting, 204
USER() function, 569
user input, in database design, 241
user requirements, in application planning, 186
user table
corrupted, 441–443
fields, 417–418
and user permissions, 421, 422
user variables, 98–102
users
access to database, 8
concurrency control. See transactions
mysql, 263, 456
PHP function to change current, 572–573
users and permissions management, 416–447
avoiding granting dangerous privileges, 446–447
granting permissions to other users, 443
limitations on users, 444–445
MySQL examination of permissions, 421–422
options when you have no permissions, 440–445
privileges, 435–436
strategy, 445–446
wildcard permissions, 439–440
USING keyword, and natural joins, 90–91
|
|