MySQL: Essential Skills

A

ABS function, 152

abstraction, 265

Access, 273275

ACOS function, 150

ADD option, 91

administration, 277312. See also MySQL Administrator

backups , 292300

disaster recovery, 301311

privileges. See privileges

server, 232234

users, 205207, 234

Windows platform, 1519, 217221

administrator-level privileges, 287288

aggregate functions, 147149

ALTER privilege, 288

ALTER TABLE statement, 9192, 100101

ampersand (@), 247, 285

AND operator, 128, 133134

AND reserved word, 250

anonymous array, 251

answers, Mastery Checks, 313324

API (application program interface), 36

apostrophe ('), 64, 261

application code, 265270

application program interface (API), 36

applications

interfacing with, 241275

open source, 35

propriety, 45

startup options, 195

third-party, 36

arithmetic operators, 338, 128, 132136

ARRAY variables , 336

arrays, 336, 251

ARROW keys, 64

AS option, 123125, 131132

ASCII function, 164

ASIN function, 150

asterisk (*), 70, 79, 121

ATAN function, 150

ATAN2 function, 150

AUTO_INCREMENT data type, 56

AUTO_INCREMENT setting, 67, 110

AVG function, 147148, 172173