MySQL: the complete reference

Select an Action

Place Hold(s)
Add to My Lists
Email
Print

Title:

Personal Author:

Vaswani, Vikram

Publication Information:

New York : McGraw Hill, 2004

ISBN:

9780072224771

Subject Term:

SQL (Computer program language)

Available:*

Library	Item Barcode	Call Number	Material Type	Item Category 1	Status
Searching... PSZ JB	30000010038100	QA76.73.S67 V54 2004	Open Access Book	Book	Searching... Unknown

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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.

Reviews 1

Library Journal Review

MySQL and PHP are perennially popular open-source companions for creating database-driven web sites. These guides cover MySQL, as well as its use with PHP and other languages. Web Database Applications goes beyond teaching particular functions to provide a general background in web database development, then describes how and why to use PHP and MySQL to accomplish the tasks described. Extensive appendixes cover the software's installment on multiple platforms, web protocols, a relational database case study, and other useful additions, while code samples are available online. Recommended for larger libraries. High Performance addresses intermediate to advanced users, walking them through ways to improve the reliability, scalability, and performance of larger MySQL applications. This nicely organized guide eschews how-to basics to address how MySQL works and provides real-world examples whenever possible. Explanations are clear and thorough, and the text supplies links to and explanations of several useful downloadable tools (some written by the authors). Highly recommended for medium and larger libraries. Complete Reference tries to be all things to all people, covering topics from an introduction to relational databases and installing and configuring MySQL to reference material for administrators, but is most appropriate for new and intermediate users. Sidebars and notes add info and link to additional resources, while a welcome thoroughness and clarity make this a good, basic purchase for all libraries. (c) Copyright 2010. Library Journals LLC, a wholly owned subsidiary of Media Source, Inc. No redistribution permitted. All rights reserved.

Foreword	p. xi
Acknowledgments	p. xiii
Introduction	p. xv
Part I Installation
1 Introduction to Databases	p. 3
The Big Picture	p. 3
...And the Little Database that Could	p. 6
History and Evolution	p. 6
Features	p. 7
Applications	p. 11
Summary	p. 12
2 A Technical Tour of MySQL	p. 13
An Overview of MySQL Architecture	p. 13
Primary Subsystems	p. 13
Support Components	p. 16
Subsystem/Component Interaction and Control Flow	p. 16
The MySQL Engine	p. 17
Connectivity	p. 17
SQL	p. 17
Data Integrity	p. 19
Transactions	p. 19
Extensibility	p. 22
Symmetric Multiprocessing with MySQL	p. 23
Security	p. 24
Replication	p. 25
Application Programming Interfaces	p. 25
Add-On Tools	p. 26
Summary	p. 26
3 MySQL Installation and Configuration	p. 27
Obtaining MySQL	p. 27
Choosing Which Version to Install	p. 28
Choosing Between Binary and Source Distributions	p. 28
Installing and Configuring MySQL	p. 30
Installing and Configuring MySQL on UNIX	p. 30
Installing and Configuring MySQL on Windows	p. 40
Testing MySQL	p. 49
Post-Installation Steps	p. 51
Summary	p. 52
Part II Usage
4 SQL Basics	p. 55
A Brief History of SQL	p. 55
An Overview of SQL	p. 56
A (My)SQL Tutorial	p. 57
Understanding an RDBMS	p. 57
Creating a Database	p. 59
Adding Tables	p. 60
Adding Records	p. 63
Removing and Modifying Records	p. 64
Executing Queries	p. 65
Summary	p. 74
5 MySQL Data Types	p. 75
The Need and Rationale for Data Types	p. 75
MySQL Data Types	p. 76
Numeric Types	p. 77
String Types	p. 82
Date and Time Types	p. 85
Complex Types	p. 93
Data Type Selection	p. 97
Summary	p. 99
6 MySQL Operators	p. 101
Arithmetic Operators	p. 102
Comparison Operators	p. 106
Logical Operators	p. 119
Bit Operators	p. 122
Summary	p. 125
7 MySQL Functions	p. 127
Math Functions	p. 128
Aggregate Functions	p. 133
String Functions	p. 137
Date and Time Functions	p. 144
Encryption Functions	p. 153
Control Flow Functions	p. 157
Formatting Functions	p. 162
Type Conversion Functions	p. 164
System Information Functions	p. 166
Summary	p. 171
8 Working with Databases and Tables	p. 173
Creating Databases	p. 173
Selecting Databases for Use	p. 175
Deleting Databases	p. 176
Creating Tables	p. 176
Field Types	p. 177
Field Constraints	p. 177
Indexes	p. 180
Primary Keys	p. 186
Foreign Keys	p. 187
Table Types	p. 196
Other Table Modifiers	p. 199
Copying Tables	p. 200
Modifying Tables	p. 204
Deleting Tables	p. 209
Obtaining Information About Databases, Tables, Fields, and Indexes	p. 209
Summary	p. 210
9 Working with Data	p. 213
Inserting, Updating, and Deleting Records	p. 213
Inserting Records	p. 213
Updating Records	p. 220
Deleting Records	p. 223
Retrieving Records	p. 226
Retrieving Specific Rows and Columns	p. 227
Using Built-In Functions	p. 228
Aliasing Table and Column Names	p. 230
Limiting Query Results	p. 230
Sorting Query Results	p. 231
Grouping Query Results	p. 233
Using Variables	p. 235
Using Subqueries	p. 236
Controlling SELECT Behavior	p. 237
Copying, Importing, and Exporting Records	p. 239
Copying Records	p. 239
Importing Records	p. 241
Exporting Records	p. 244
Summary	p. 247
10 Joins	p. 249
What Is a Join?	p. 249
Types of Joins	p. 252
Cross Joins	p. 253
Inner Joins	p. 254
Outer Joins	p. 256
Self Joins	p. 262
Unions	p. 265
Summary	p. 267
11 Subqueries	p. 269
What Is a Subquery?	p. 270
Types of Subqueries	p. 274
Subqueries and the Where/Having Clause	p. 274
Subqueries and the From Clause	p. 282
Subqueries and Joins	p. 284
Subqueries and Other DML Statements	p. 286
Summary	p. 290
12 Transactions	p. 291
What Is a Transaction?	p. 292
Transactions and the ACID Properties	p. 294
Life Cycle of a Transaction	p. 296
Controlling Transactional Behavior	p. 300
Automatic Commits	p. 300
Transaction Isolation Levels	p. 302
Transactions and Performance	p. 307
Pseudotransactions with Nontransactional Tables	p. 310
Table Locks as a Substitute for Transactions	p. 311
Implementing a Pseudotransaction with Table Locks	p. 315
Summary	p. 316
Part III Administration
13 Administration and Configuration	p. 319
Database Administration and MySQL	p. 319
Uptime	p. 320
Data Backup	p. 320
Security and Access Control	p. 321
Performance Optimization	p. 321
Basic Server Administration and Configuration Tasks	p. 322
Starting and Stopping the Server	p. 323
Checking MySQL Server Status	p. 326
Managing MySQL Client Processes	p. 327
Altering the Server Configuration	p. 328
Troubleshooting with the Error Log	p. 333
Summary	p. 334
14 Security, Access Control, and Privileges	p. 335
The MySQL Grant Tables	p. 335
The user Table	p. 336
The db and host Tables	p. 340
The tables_priv and columns_priv Tables	p. 342
Granting, Revoking, and Viewing User Privileges	p. 345
Using the Grant and Revoke Commands	p. 346
Using the Insert, Update, and Delete Commands	p. 351
Viewing Privileges	p. 352
Reloading the Grant Tables	p. 352
Resetting the Grant Tables	p. 353
Changing User Passwords	p. 353
Setting the root Password	p. 355
Resetting the root Password	p. 355
Summary	p. 356
15 Maintenance, Backup, and Recovery	p. 357
Maintenance	p. 357
Logging	p. 357
Checking and Repairing Tables	p. 361
Backup and Restore	p. 365
Backing Up Databases and Tables	p. 365
Restoring Databases and Tables from Backup	p. 367
Summary	p. 369
16 Performance Optimization	p. 371
Indexing	p. 371
Query Caching	p. 374
Query Analysis	p. 376
Optimizing Multi-Table Queries	p. 378
Using Temporary Tables	p. 380
Optimizing Table Design	p. 381
Adjusting Server Settings	p. 382
Benchmarking	p. 383
Summary	p. 388
17 MySQL Replication	p. 389
Replication Basics	p. 389
The Master-Slave Relationship	p. 390
Replication Threads	p. 390
Configuring MySQL for Replication	p. 391
Managing the Replication Process	p. 393
Summary	p. 398
Part IV Development
18 The MySQL APIs	p. 401
The MySQL APIs In Context	p. 401
Components of the MySQL API	p. 402
Language Support	p. 403
Selecting an API	p. 405
Summary	p. 409
19 MySQL and C	p. 411
C	p. 411
History and Evolution	p. 411
Installation	p. 412
MySQL and C	p. 412
Connection Management	p. 417
Query Execution	p. 419
Result Set Processing	p. 421
Error Handling	p. 429
Ancillary Functions	p. 431
Real-World Usage	p. 433
The Interactive SQL Client	p. 433
The Expense Tracker	p. 437
Summary	p. 443
20 MySQL and Perl	p. 445
Perl	p. 445
History and Evolution	p. 445
Installation	p. 446
MySQL and the Perl DBI	p. 447
Connection Management	p. 451
Query Execution	p. 454
Result Set Processing	p. 457
Error Handling	p. 461
Ancillary Functions	p. 465
A Real-World Example	p. 465
Designing the Database	p. 466
Building an Article Index	p. 468
Retrieving Article Contents	p. 470
Adding Comments	p. 473
Building a Threaded Comment Index	p. 477
Viewing Comments	p. 481
Summary	p. 484
21 MySQL and PHP	p. 485
PHP: History and Evolution	p. 485
Installation	p. 486
MySQL and PHP	p. 488
Connection Management	p. 493
Query Execution	p. 494
Result Set Processing	p. 498
Error Handling	p. 505
Ancillary Functions	p. 505
A Real-World Example	p. 508
Designing the Database	p. 509
Retrieving Data	p. 510
Adding Data	p. 512
Removing Data	p. 516
Summary	p. 520
Index	p. 521

Available:*

On Order

Summary

Summary

Reviews 1

Library Journal Review

Table of Contents