9780131497351

SQL for MySQL Developers A Comprehensive Tutorial and Reference: A Comprehensive Tutorial and Reference

by
  • ISBN13:

    9780131497351

  • ISBN10:

    0131497359

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2007-04-20
  • Publisher: Addison-Wesley Professional
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $59.99 Save up to $9.00
  • Buy New
    $50.99
    Add to Cart Free Shipping

    CURRENTLY AVAILABLE, USUALLY SHIPS IN 24-48 HOURS

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

The Most Complete and Practical Guide to MySQL Version 5rs"s Powerful SQL Dialect MySQL version 5 offers a SQL dialect with immense power. InSQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statementincluding advanced features that make iteasier to create even the most complex statements and programs. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQLrs"s dialect works as it doesand how to get the most out of it. Yours"ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether yours"re a programmer, Web developer, analyst, DBA, or database user, this book can take you from "apprentice" to true SQL expert. If yours"ve used SQL in older versions of MySQL, yours"ll become dramatically more effectiveand if yours"re migrating from other database platforms, yours"ll gain practical masteryfast. Coverage includes Writing queries, including joins, functions, and subqueries Updating data Creating tables, views, and other database objects Specifying keys and other integrity constraints Improving efficiency with indexes Enforcing security via passwords and privileges Embedding SQL statements within PHP programs Building stored procedures and triggers Using transactions, locking, rollback, and isolation levels Utilizing MySQLrs"s catalog All of the bookrs"s sample programs are available for download from www.r20.nl. About the Author RickF. van der Lansis author of the classicIntroduction to SQL, the definitive SQL guide that database developers have relied on for more than 20 years. He is a consultant, author, and lecturer specializing in database technology, development tools, data warehousing, and XML. As managing director of the Netherlands-based R20/Consultancy, he has advised many large companies on defining their IT architectures. He chairs the European Meta Data Conference, and writes columns for several magazines. Contents About the Author xix Preface xx PART I Introduction 1 CHAPTER 1 Introduction to MySQL 3 CHAPTER 2 The Tennis Club Sample Database 29 CHAPTER 3 Installing the Software 37 CHAPTER 4 SQL in a Nutshell 41 PART II Querying and Updating Data 71 CHAPTER 5 SELECT Statement: Common Elements 73 CHAPTER 6 SELECT Statements, Table Expressions, and Subqueries 145

Author Biography

Rick F. van der Lans is author of the classic Introduction to SQL, the definitive SQL guide that database developers have relied on for more than 20 years. He is a consultant, author, and lecturer specializing in database technology, development tools, data warehousing, and XML. As managing director of the Netherlands-based R20/Consultancy, he has advised many large companies on defining their IT architectures. He chairs the European Meta Data Conference, and writes columns for several magazines.

Table of Contents

About the Authorp. xix
Prefacep. xx
Introductionp. 1
Introduction to MySQLp. 3
The Tennis Club Sample Databasep. 29
Installing the Softwarep. 37
SQL in a Nutshellp. 41
Querying and Updating Datap. 71
Select Statement
Common Elementsp. 73
Select Statements
Table Expressions, and Subqueriesp. 145
Select Statement
The From Clausep. 171
Select Statement
The Where Clausep. 213
Select Statement
Select Clause and Aggregation Functionsp. 315
Select Statement
The Group BY Clausep. 349
Select Statement
The Having Clausep. 375
Select Statement
The Order By Clausep. 383
Select Statement
The Limit Clausep. 395
Combining Table Expressionsp. 409
The User Variable and the SET Statementp. 421
The HANDLER Statementp. 429
Updating Tablesp. 437
Loading and Unloading Datap. 461
Working with XML Documentsp. 471
Creating Database Objectsp. 491
Creating Tablesp. 493
Specifying Integrity Constraintsp. 539
Character Sets and Collationsp. 561
The ENUM and SET Typesp. 577
Changing and Dropping Tablesp. 591
Using Indexesp. 603
Viewsp. 631
Creating Databasesp. 653
Users and Data Securityp. 659
Statements for Table Maintenancep. 683
The Show, Describe, and HELP Statementsp. 693
Procedural Database Objectsp. 701
Stored Proceduresp. 703
Stored Functionsp. 745
Triggersp. 755
Eventsp. 767
Programming with SQLp. 783
MySQL and PHPp. 785
Dynamic SQL with Prepared Statementp. 807
Transactions and Multiuser Usagep. 815
Syntax of SQLp. 839
Scalar Functionsp. 903
System Variablesp. 953
Bibliographyp. 963
Indexp. 967
Table of Contents provided by Publisher. All Rights Reserved.

Excerpts

= 0) {slash = '\\';} else {slash = '/';}openLoc = figLoc.substring(0, figLoc.lastIndexOf(slash) + 1);while (pPage.substring(0,3) == '../') {openLoc = openLoc.substring(0, openLoc.lastIndexOf(slash, openLoc.length - 2)+ 1);pPage = pPage.substring(3, pPage.length + 1);}popUpWin =window.open('','popWin','resizable=1,scrollbars=1,location=0,toolbar=0,width=525,height=394');figDoc = popUpWin.document;zhtm= ' ' + pPage + ' ';zhtm += ' ';zhtm += ' ';zhtm += ' ';zhtm += '' + pPage.substring(pPage.lastIndexOf('/') + 1, pPage.length) + '';zhtm += ' ';figDoc.write(zhtm);figDoc.close();}// modified 3.1.99 RWE v4.1 --> SQL for MySQL Developers SQL for MySQL Developers Preface IntroductionMany books have been written about MySQL, the best-known open source database server. Then why another book? Most books about MySQL discuss a wide variety of topics, such as the installation of MySQL, using MySQL from PHP, and security. As a result, each topic cannot be explained in detail, and many questions of readers cannot be answered. This book focuses on one aspect of MySQL: the language that drives MySQL, which isSQL(Structured Query Language). Every developer working with MySQL should master this language thoroughly.Especially in the more recent versions, SQL has been extended considerably. Unfortunately, many developers still limit themselves to those features that were available in the first versions. Not all the features of MySQL are fully used, which means that the product is not employed in the best way possible. The result is that complex statements and programs must be built needlessly. When you buy a house, you also do not restrict yourself to 20 percent of the rooms, do you? That is why this book contains a complete and detailed description of the SQL dialect as implemented in MySQL version 5.0.18. It should be seen primarily as a textbook rather than as a reference book; it will teach you the language, and you can complete the exercises to test your knowledge. After reading this book, you should be familiar with all the statements and features and some idiosyncrasies of MySQL's SQL, and you should be able to use it efficiently and effectively. TopicsThis book is completely devoted to the SQL dialect as implemented in MySQL. It discusses every aspect of the language thoroughly and critically. These aspects of SQL among others, are covered:Querying data (joins, functions, and subqueries)Updating dataCreating tables and viewsSpecifying primary and foreign keys and other integrity constraintsUsing indexesConsidering data security

Rewards Program

Write a Review