MySQL: Essential Skills

P

padding, strings, 161162

page-level locking, 60

parentheses (), 63, 338

passwords

connection, 195

described, 278

importance of, 287

Linux systems, 27

MySQL Administrator, 204

privileges, 287

root, 204, 278279

Windows systems, 14

PEAR libraries, 266

PEAR::DB modules, 265267

percent symbol (%), 151, 159, 285

performance, 23, 203

period (.), 54

PHP, 242265

activation of, 331

comments, 333, 337

control structures, 342345

functions, 341342

installation, 331332

MySQL and, 330

open source, 330

overview, 330

resources, 330

setting up, 331

syntax, 333338

variables , 334338

warnings, 247

PHP 5, 263, 265

PHP Extension and Application Repository. See PEAR

.php files, 331

PHP-GTK (GIMP Tool Kit), 243

PHP tags, 332333

PHPDoc, 337

PI function, 149

.pid file, 279

ping function, 246

plus sign (+), 167

ports, changing, 24

POW function, 151

POWER function, 151

powers, 150152

precedence levels, 339341

prepare () method, 267268

PRINT command, 338

privileges, 278292

administrator-only, 287288

columns , 207

common-level, 282

database-level, 282

described, 278

GLOBAL, 287

global-level, 207, 282

granting, 281286

levels, 281282

management of, 287288

refreshing, 287

removal of, 281282, 286287

revoking, 281282, 286287, 291

schema, 207

setting, 278, 289292

table-level, 207, 282

types of, 282285

procedural mode, 263

PROCESS privilege, 288

Process tab, 18

programs. See applications

pseudo-typeless variables, 334338