MySQL: Learn MySQL the Quick and Easy Way

✍ Scribed by Ullman, Larry

• Publisher: Peachpit Press
• Year: 2006
• Tongue: English
• Leaves: 481
• Series: Visual QuickStart Guide
• Edition: 2nd edition
• Category: Library

✦ Synopsis

Even if you've never used MySQL before, thisVisual QuickStart Guidewill have you up and running with the world's most popular open source database application in no time. In this completely updated edition of our best-selling guide to MySQL, leading technology authorLarry Ullmanuses his trademark crystal-clear instructions and friendly prose to introduce you to everything that's new in MySQL. Filled with step-by-step, task-based instructions and loads of visual aids, this book explains how to interact with MySQL using SQL, the language common to all databases. The interface examples show how to use MySQL's own tools and how to use three popular programming languages (PHP, Perl, and Java). The book covers MySQL versions 3 and 4, as well as everything new in the eagerly anticipated version 5. Along the way, you'll find extensive coverage of MySQL installation, administration, database design, as well as its use with various programming languages, database programming techniques, utilities, advanced MySQL and SQL, and more!

-Takes an easy, visual approachto teaching MySQL, using pictures to guide you through the software and show you what to do.
-Works like a reference book--you look up what you need and then get straight to work.
-No long-winded passages--concise, straightforward commentary explains what you need to know.
-Affordably priced,because buying a computer book shouldn't be an investment in itself.
-Companion Web siteatwww.DMCInsights.com/mysql2contains complete source code for examples in the book, online resources, extra scripts and tutorials, updates, a reader forum, and more.

✦ Table of Contents

Cover......Page 1
Contents......Page 6
Introduction......Page 10
Chapter 1: Installing MySQL......Page 18
General Installation Steps......Page 19
Installing MySQL on Windows......Page 22
Configuring MySQL on Windows......Page 25
Installing MySQL on Macintosh......Page 27
Installing MySQL on Linux......Page 30
Basic Configuration Options......Page 35
Upgrading MySQL......Page 38
Chapter 2: Running MySQL......Page 40
Running MySQL on Windows and Windows NT......Page 41
Running MySQL on Mac OS X......Page 50
Running MySQL on Linux and Unix......Page 53
Using mysqladmin......Page 56
Setting the Root User Password......Page 59
Using the mysql Client......Page 61
Users and Privileges......Page 65
Chapter 3: Database Design......Page 74
Normalization......Page 75
Understanding Keys......Page 76
Understanding Relationships......Page 78
First Normal Form......Page 80
Second Normal Form......Page 82
Third Normal Form......Page 85
Chapter 4: Creating a MySQL Database......Page 88
MySQL Data Types......Page 89
Extra Column Characteristics......Page 94
Introduction to Indexes......Page 97
Finalizing a Table’s Design......Page 99
Choosing a Storage Engine......Page 102
Character Sets and Collations......Page 105
Creating Databases......Page 108
Creating Tables......Page 110
Modifying Tables......Page 115
Chapter 5: Basic SQL......Page 118
Using Values in Queries......Page 119
Inserting Data......Page 121
Selecting Data......Page 125
Using Conditionals......Page 128
Using LIKE and NOT LIKE......Page 131
Performing Joins......Page 134
Sorting Query Results......Page 140
Limiting Query Results......Page 142
Updating Data......Page 144
Deleting Data......Page 146
Chapter 6: MySQL Functions......Page 150
Text Functions......Page 151
Concatenation and Aliases......Page 154
Numeric Functions......Page 159
Date and Time Functions......Page 162
Formatting the Date and Time......Page 166
Encryption Functions......Page 168
Grouping Functions......Page 171
Other Functions......Page 174
Chapter 7: MySQL and PHP......Page 178
Connecting to MySQL and Selecting a Database......Page 179
Executing Simple Queries......Page 183
Retrieving Query Results......Page 191
Using mysqli_insert_id()......Page 199
Error Handling......Page 206
Security Considerations......Page 209
Chapter 8: MySQL and Perl......Page 222
Installing Perl with MySQL Support on Windows......Page 223
Installing Perl Support for MySQL on Unix and Mac OS X......Page 226
Testing Perl and MySQL......Page 228
Connecting to MySQL......Page 232
Retrieving Query Results......Page 235
Executing Simple Queries......Page 239
Retrieving the Insert ID......Page 244
Error Handling......Page 247
Security Considerations......Page 251
Using Prepared Statements......Page 254
Chapter 9: MySQL and Java......Page 260
Installing Java Support for MySQL......Page 261
Connecting to the Database......Page 264
Executing Simple Queries......Page 271
Retrieving Query Results......Page 278
Retrieving the Insert ID......Page 285
Using Prepared Statements......Page 291
Chapter 10: Advanced SQL and MySQL......Page 296
Performing Transactions......Page 297
Full-Text Searching......Page 304
Regular Expressions......Page 314
User-Defined Variables......Page 317
Introducing Unions......Page 320
Chapter 11: MySQL 5 Features......Page 326
Stored Routines......Page 327
Using OUT Parameters......Page 347
Triggers......Page 350
Views......Page 355
Chapter 12: Techniques for Programming......Page 362
Storing and Retrieving Binary Data......Page 363
Making Query Result Pages......Page 381
Using Transactions with Perl......Page 395
Chapter 13: MySQL Administration......Page 404
The MySQL Administrator......Page 405
Backing Up Databases......Page 409
Importing Data......Page 413
MySQL Logging......Page 415
Database Maintenance......Page 418
Improving Performance......Page 422
Using Batch Files......Page 426
Appendix A: Troubleshooting......Page 430
Installation......Page 431
Starting MySQL......Page 432
Accessing MySQL......Page 433
mysql.sock Problems......Page 435
Queries That Return Strange Results......Page 437
Authentication Protocol Problems......Page 438
Resetting the Root Password......Page 439
Appendix B: SQL and MySQL References......Page 442
Basic SQL......Page 443
ALTER Commands......Page 445
SQL Clauses......Page 446
MySQL Privileges......Page 447
MySQL Data Types......Page 448
MySQL Functions......Page 450
Other References......Page 454
Appendix C: Resources......Page 456
MySQL-Specific......Page 457
Third-Party MySQL Applications......Page 459
SQL......Page 460
PHP......Page 461
Perl......Page 462
Java......Page 463
Other......Page 464
A......Page 466
C......Page 467
D......Page 469
E......Page 470
G......Page 471
J......Page 472
M......Page 473
P......Page 475
Q......Page 476
S......Page 477
T......Page 479
W......Page 480
Z......Page 481

✦ Subjects

Computer Science;Programming;Nonfiction;Reference;Computers