×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

MySQL: The Complete Reference / Edition 1
     

MySQL: The Complete Reference / Edition 1

by Vikram Vaswani, Pamela Smith
 

See All Formats & Editions

ISBN-10: 0072224770

ISBN-13: 9780072224771

Pub. Date: 01/28/2004

Publisher: McGraw-Hill Professional Publishing

Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.

Overview

Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.

Product Details

ISBN-13:
9780072224771
Publisher:
McGraw-Hill Professional Publishing
Publication date:
01/28/2004
Series:
Osborne Complete Reference Series
Pages:
544
Product dimensions:
7.30(w) x 9.10(h) x 1.45(d)

Table of Contents

Forewordxi
Acknowledgmentsxiii
Introductionxv
Part IInstallation
1Introduction to Databases3
The Big Picture3
...And the Little Database that Could6
History and Evolution6
Features7
Applications11
Summary12
2A Technical Tour of MySQL13
An Overview of MySQL Architecture13
Primary Subsystems13
Support Components16
Subsystem/Component Interaction and Control Flow16
The MySQL Engine17
Connectivity17
SQL17
Data Integrity19
Transactions19
Extensibility22
Symmetric Multiprocessing with MySQL23
Security24
Replication25
Application Programming Interfaces25
Add-On Tools26
Summary26
3MySQL Installation and Configuration27
Obtaining MySQL27
Choosing Which Version to Install28
Choosing Between Binary and Source Distributions28
Installing and Configuring MySQL30
Installing and Configuring MySQL on UNIX30
Installing and Configuring MySQL on Windows40
Testing MySQL49
Post-Installation Steps51
Summary52
Part IIUsage
4SQL Basics55
A Brief History of SQL55
An Overview of SQL56
A (My)SQL Tutorial57
Understanding an RDBMS57
Creating a Database59
Adding Tables60
Adding Records63
Removing and Modifying Records64
Executing Queries65
Summary74
5MySQL Data Types75
The Need and Rationale for Data Types75
MySQL Data Types76
Numeric Types77
String Types82
Date and Time Types85
Complex Types93
Data Type Selection97
Summary99
6MySQL Operators101
Arithmetic Operators102
Comparison Operators106
Logical Operators119
Bit Operators122
Summary125
7MySQL Functions127
Math Functions128
Aggregate Functions133
String Functions137
Date and Time Functions144
Encryption Functions153
Control Flow Functions157
Formatting Functions162
Type Conversion Functions164
System Information Functions166
Summary171
8Working with Databases and Tables173
Creating Databases173
Selecting Databases for Use175
Deleting Databases176
Creating Tables176
Field Types177
Field Constraints177
Indexes180
Primary Keys186
Foreign Keys187
Table Types196
Other Table Modifiers199
Copying Tables200
Modifying Tables204
Deleting Tables209
Obtaining Information About Databases, Tables, Fields, and Indexes209
Summary210
9Working with Data213
Inserting, Updating, and Deleting Records213
Inserting Records213
Updating Records220
Deleting Records223
Retrieving Records226
Retrieving Specific Rows and Columns227
Using Built-In Functions228
Aliasing Table and Column Names230
Limiting Query Results230
Sorting Query Results231
Grouping Query Results233
Using Variables235
Using Subqueries236
Controlling SELECT Behavior237
Copying, Importing, and Exporting Records239
Copying Records239
Importing Records241
Exporting Records244
Summary247
10Joins249
What Is a Join?249
Types of Joins252
Cross Joins253
Inner Joins254
Outer Joins256
Self Joins262
Unions265
Summary267
11Subqueries269
What Is a Subquery?270
Types of Subqueries274
Subqueries and the Where/Having Clause274
Subqueries and the From Clause282
Subqueries and Joins284
Subqueries and Other DML Statements286
Summary290
12Transactions291
What Is a Transaction?292
Transactions and the ACID Properties294
Life Cycle of a Transaction296
Controlling Transactional Behavior300
Automatic Commits300
Transaction Isolation Levels302
Transactions and Performance307
Pseudotransactions with Nontransactional Tables310
Table Locks as a Substitute for Transactions311
Implementing a Pseudotransaction with Table Locks315
Summary316
Part IIIAdministration
13Administration and Configuration319
Database Administration and MySQL319
Uptime320
Data Backup320
Security and Access Control321
Performance Optimization321
Basic Server Administration and Configuration Tasks322
Starting and Stopping the Server323
Checking MySQL Server Status326
Managing MySQL Client Processes327
Altering the Server Configuration328
Troubleshooting with the Error Log333
Summary334
14Security, Access Control, and Privileges335
The MySQL Grant Tables335
The user Table336
The db and host Tables340
The tables_priv and columns_priv Tables342
Granting, Revoking, and Viewing User Privileges345
Using the Grant and Revoke Commands346
Using the Insert, Update, and Delete Commands351
Viewing Privileges352
Reloading the Grant Tables352
Resetting the Grant Tables353
Changing User Passwords353
Setting the root Password355
Resetting the root Password355
Summary356
15Maintenance, Backup, and Recovery357
Maintenance357
Logging357
Checking and Repairing Tables361
Backup and Restore365
Backing Up Databases and Tables365
Restoring Databases and Tables from Backup367
Summary369
16Performance Optimization371
Indexing371
Query Caching374
Query Analysis376
Optimizing Multi-Table Queries378
Using Temporary Tables380
Optimizing Table Design381
Adjusting Server Settings382
Benchmarking383
Summary388
17MySQL Replication389
Replication Basics389
The Master-Slave Relationship390
Replication Threads390
Configuring MySQL for Replication391
Managing the Replication Process393
Summary398
Part IVDevelopment
18The MySQL APIs401
The MySQL APIs In Context401
Components of the MySQL API402
Language Support403
Selecting an API405
Summary409
19MySQL and C411
C411
History and Evolution411
Installation412
MySQL and C412
Connection Management417
Query Execution419
Result Set Processing421
Error Handling429
Ancillary Functions431
Real-World Usage433
The Interactive SQL Client433
The Expense Tracker437
Summary443
20MySQL and Perl445
Perl445
History and Evolution445
Installation446
MySQL and the Perl DBI447
Connection Management451
Query Execution454
Result Set Processing457
Error Handling461
Ancillary Functions465
A Real-World Example465
Designing the Database466
Building an Article Index468
Retrieving Article Contents470
Adding Comments473
Building a Threaded Comment Index477
Viewing Comments481
Summary484
21MySQL and PHP485
PHP: History and Evolution485
Installation486
MySQL and PHP488
Connection Management493
Query Execution494
Result Set Processing498
Error Handling505
Ancillary Functions505
A Real-World Example508
Designing the Database509
Retrieving Data510
Adding Data512
Removing Data516
Summary520
Index521

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews