MySQL (5th Edition) (Developer's Library)
Format: PDF / Kindle (mobi) / ePub
MySQL, Fifth Edition by Paul DuBois
The definitive guide to using, programming and administering MySQL 5.5 and MySQL 5.6
MySQL provides a comprehensive guide to effectively using and administering the MySQL database management system (DBMS).
Author Paul DuBois describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The book also includes a comprehensive reference section providing detailed information on MySQL’s structure, language, syntax, and APIs.
The fifth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.5, as well as to add new coverage of features introduced with MySQL 5.6.
MySQL is an open source relational database management system (DBMS) that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications. MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it.
Paul DuBois' MySQL, Fifth Edition, is the definitive guide to fully exploiting all the power and versatility of MySQL 5.5 and MySQL 5.6
Contents at a Glance
Part I: General MySQL Use
Chapter 1 Getting Started with MySQL
Chapter 2 Using SQL to Manage Data
Chapter 3 Data Types
Chapter 4 Views and Stored Programs
Chapter 5 Query Optimization
Part II: Using MySQL Programming Interfaces
Chapter 6 Introduction to MySQL Programming
Chapter 7 Writing MySQL Programs Using C
Chapter 8 Writing MySQL Programs Using Perl DBI
Chapter 9 Writing MySQL Programs Using PHP
Part III: MySQL Administration
Chapter 10 Introduction to MySQL Administration
Chapter 11 The MySQL Data Directory
Chapter 12 General MySQL Administration
Chapter 13 Security and Access Control
Chapter 14 Database Maintenance, Backups, and Replication
Part IV: Appendixes
Appendix A Software Required to Use This Book
Appendix B Data Type Reference
Appendix C Operator and Function Reference
Appendix D System, Status, and User Variable Reference
Appendix E SQL Syntax Reference
Appendix F MySQL Program Reference
Appendix I PHP API Reference
procedures, views, and triggers.These capabilities take MySQL into the realm of enterprise applications.As a result, people who once would have considered only “big iron” database systems for their applications now give serious consideration to MySQL. MySQL is portable and runs on commercial operating systems (such as Mac OS X, HP-UX, and Windows) and on hardware all the way up to enterprise servers. Furthermore, its performance rivals any database system you care to put up against it, and it can
books are available at most retail and online bookstores, as well as by subscription from Safari Books Online at safari.informit.com. Developer’s Library informit.com/devlibrary MySQL ® Fourth Edition Paul DuBois Upper Saddle River, NJ • Boston • Indianapolis • San Francisco New York • Toronto • Montreal • London • Munich • Paris • Madrid Cape Town • Sydney • Tokyo • Singapore • Mexico City MySQL ® Fourth Edition Acquisitions Editor Mark Taber Copyright © 2009 by Pearson Education, Inc.
have in mind. No, in the sense that it also would delete the row for Franklin Roosevelt. It’s safer to check the WHERE clause with a SELECT statement first, like this: mysql> SELECT last_name, first_name FROM president -> WHERE last_name='Roosevelt'; +-----------+-------------+ | last_name | first_name | +-----------+-------------+ | Roosevelt | Theodore | | Roosevelt | Franklin D. | +-----------+-------------+ 91 92 Chapter 1 Getting Started with MySQL From that you can see the need to be
system, you must refer to it using the same lettercase throughout a given query.That is not true for SQL keywords, function names, or column and index names, all of which may be referred to in varying lettercase style throughout a query. However, the query will be more readable if you use a consistent lettercase rather than mixed lettercase (SelECt NamE FrOm ...). 2.4 Character Set Support MySQL supports multiple character sets, and character sets can be specified independently at the server,
and table subqueries that return more information cannot be used in contexts that require a single value. 2.9 Performing Multiple-Table Retrievals with Subqueries Subqueries can be correlated or uncorrelated.This is a function of whether a subquery refers to and is dependent on values in the outer query. You can use subqueries with statements other than SELECT. However, for statements that modify tables (INSERT, REPLACE, DELETE, UPDATE, LOAD DATA) there is currently a restriction that the