Index_U

U

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



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net