Table of contents for Learning MySQL / Seyed M.M. "Seyed" Tahaghoghi and Hugh E. Williams.


Bibliographic record and links to related information available from the Library of Congress catalog
Note: Electronic data is machine generated. May be incomplete or contain other coding.


Counter
WbIy Is NySQL so Popular?                                        4
Eleirlents of ySQL and Its Environmient                          5
MySQ L Software Covered in This Book                            /
The1 Book's Web Site                                              8
2.   nstalling  MySQL  ...      ..................                    9
Insiluation Choices and Platforms                                9
Using the Conmmarnd-Line Interface                              12
Using a Text Editor                                             18
Following the instructions in This Book                         19
Downloading in( Verifying Files from the My>SQL AB Web ite      21
Installing Under Li nux                                         25
Instafling t nde, Win dows                                      51
Installing Under Mac OS X                                       61
Us ing MySQL Installation Provided by an ISP                    69
pg.'irading an Eisting MISQO  erver                             69
Coniguring Access to the MySQL Server                           73
Wthat i t Things Don't  ork,                                    74
The onte ns of the MiySQL Directory                             80
Configuring and Controlling the Apache Web Server               83
1 i ng 1in  E Pe                                                87
Resources                                                       92
Exercises                                                       93
S3.  sing the MySQL Monitor  ..... ......  1  .  ....... ;........ 95
Ustring theM Monitor                                            95
Style, Case, 3and Sem,colons                                      97
The Moniteor Help                                                 98
Running the Monitor in Batch Mode                                101
"L oading the 'rnpie Databases                                   102
MyvSOL Monitor Program Options                                   102
Graphical Clients                                                104
Exercises                                                        105
Part .    Using MySQL
4.   Modeing and Designing Databases     ...............   ..........  109
How Not to Develop a Database                                    109
Ihe Database Design Process                                      11
The Entity RetionLship lodel                                     112
Entity Relationship Modeing Examples                            120
sing the Entity Relationship Model                               128
Usingii  Tools for Database Design                               129
Resou ces                                                        131
Exercises                                                        132
5   Bas   SQL      ...............  ......  ..................  .....  135
.siUg the Music Datiabase                                        135
PThe SEl EC'T [ Statenent ;and Basic Querying Techniques         1 39
The INSERT Stat-ment                                             162
The DELETE Statement                                             168
T he UPDA TE Statement                                           171
Exploring Dan bases md T ables with SHOW and mysqishow          .173
Exercises                                                        176
6.   Working with Database Structures  .  ....     ....  .1     ...... 179
Creating and Using Databases                                     179
Creating Tables                                                  181
T he Sample Music Database                                       212
Altering Structures                                              214
Dietring Structures                                              220
Exercises
7.   Advanced Querying      ............    ........                  223
Aliaseis                                                         223
Aggregating Datn a                                               228
Advanced Joins                                                   236
Nested  ueries                                                   250
1 ser Variables                                                263
Transactions and Locking                                       266
Table Types                                                    267
Exercises                                                     Z2k7 5
8.   Doing More with MySQL ........ .....     .    . r*...     1 277
Inserting Data Using Queries                                   277
oacing Data tfrom Comma-Delimited Files                        281
Writing Data into Comma-Delimited Files                        284
Creating Tables with Queries                                   285
Updates and Deletes with Multiple Tables                       288
Replacing Da ta                                                292
The EXPLAIN Statement                                          294
Exercises                                                      295
9.   Managing Users and Privileges .2: ........ . r I;  :.         297
Understanding Users and Privileges                             298
Creating anid Using New Users                                  299
Privileges                                                     303
The GRANT OPT'ION Privilege                                    306
How Privileges Interact                                        307
Users and Hosts                                                308
Checking Privileges                                            317
Revoking Privileges                                            322
Removing Users                                                 323
Understanding and Changing Passwords                           324
The Default Users                                              328
Devising a User Security Policy                                333
Managing Privileges with SQL                                   339
Pnrivileges and Performance                                    346
Resetting Forgotten MySQL Passwords                            347
Exercises                                                      349
Part III. Advanced Topi cs
10.  Backups and Recovery  ...................  ........     ..  ... 353
Dumping a Database as SQL Statements                           353
Loading Data from an SQL Dump File                             360
riysiqutcbopy                                                  361
Schedulrng Backups                                             361
The Binary Log                                                 365
Chec king and Repairing Corrupcted Tables                      366
Re- Creating Damaged Grant Tables                               369
Resources                                                       369
Exercises                                                       369
11.  Using an Options Fie  ...                                       371.... .. ..  .   .. . .. ..   371
Configuring Options for the 


Library of Congress subject headings for this publication: MySQL (Electronic resource)PHP (Computer program language)SQL (Computer program language)Web databases