Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Best Books of the Year | December 7, 2014

    Gigi Little: IMG Best Kids' Books of 2014



    No, I'm sorry, it's impossible. The best kids' books of 2014? The best? Can't do it. There have been entirely too many exceptional examples of the... Continue »
    1. $11.87 Sale Board Book add to wish list

      Countablock

      Christopher Franceschelli and Peskimo 9781419713743

    spacer
Qualifying orders ship free.
$49.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
5 Local Warehouse Database- Design
5 Remote Warehouse Computer Languages- SQL

This title in other editions

MySQL (Developer's Library)

by

MySQL (Developer's Library) Cover

 

Synopses & Reviews

Publisher Comments:

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

Online Appendixes:

Appendix G C API Reference
Appendix H Perl DBI API Reference

Appendix I PHP API Reference

Synopsis:

This is the definitive, best-selling guide to using, programming, and administering MySQL 5.5, the newest version of the world's #1 open source database. Authored by Paul DuBois, the open source community leader who now leads MySQL's own English language documentation team, this guide is perfect for MySQL users at all levels of experience, in roles ranging from web developer to database administrator. Fully updated to reflect the final stable version of MySQL 5.5, MySQL, Fifth Edition has been meticulously revised and updated to cover important new features that extend MySQL's power and make it even more valuable in large-scale enterprise environments. Throughout, DuBois focuses on the productive and effective use of MySQL in real-world environments. DuBois covers all this: efficiently capturing information in a MySQL database, and formulating queries to retrieve it; using MySQL with PHP or Perl to generate dynamic web pages; writing programs that access MySQL databases; administering MySQL servers; controlling database access and enforcing security; maintaining, backing up, and replicating MySQL databases, and much more. This Fifth Edition incorporates extensive feedback from both readers and top developers throughout the MySQL global community, and also includes significantly expanded coverage of stored procedures, functions, triggers, and events.

About the Author

Paul DuBois is a writer, database administrator, and leader in the open source and MySQL communities. He has contributed to the online documentation for MySQL and is the author of MySQL and Perl for the Web (New Riders), MySQL Cookbook, Using csh and tcsh, and Software Portability with imake (O’Reilly). He is currently a technical writer with the MySQL documentation team at Oracle Corporation.

Table of Contents

Part I. General MySQL Use

1. Getting Started with MySQL and SQL

2. MySQL SQL Syntax and Use

3. Working with Data in MySQL

4. Stored Programs

5. Query Optimization

Part II. Using MySQL Programming Interfaces

6. Introduction to MySQL Programming

7. Writing MySQL Programs Using C

8. Writing MySQL Programs Using Perl DBI

9. Writing MySQL Programs Using PHP

Part III. MySQL Administration

10. Introduction to MySQL Administration

11. The MySQL Data Directory

12. General MySQL Administration

13. MySQL and Security

14. Database Backups, Maintenance, and Repair

Appendixes

A. Obtaining and Installing Software

B. Data Type Reference

C. Operator and Function Reference

D. System, Status, and User Variable Reference

E. SQL Syntax Reference

F. MySQL Program Reference

Product Details

ISBN:
9780321833877
Author:
Dubois, Paul
Publisher:
Addison-Wesley Professional
Author:
DuBois, Paul
Subject:
Database design
Subject:
Programming Languages - SQL
Subject:
databases; programming; MySQL 5.5; MySQL 5.6; Professional MySQL; Learning MySQL; MySQL Reference; MySQL For Dummies; Definitive MySQL; MySQL Administration; MySQL In a Nutshell; MySQL Crash Course; MySQL Optimization; MySQL Workbench; tutorial; reference
Subject:
databases; programming; MySQL 5.5; MySQL 5.6; Professional MySQL; Learning MySQL; MySQL Reference; MySQL For Dummies; Definitive MySQL; MySQL Administration; MySQL In a Nutshell; MySQL Crash Course; MySQL Optimization; MySQL Workbench; tutorial; reference
Subject:
databases; programming; MySQL 5.5; MySQL 5.6; Professional MySQL; Learning MySQL; MySQL Reference; MySQL For Dummies; Definitive MySQL; MySQL Administration; MySQL In a Nutshell; MySQL Crash Course; MySQL Optimization; MySQL Workbench; tutorial; reference
Subject:
Database Management - General
Subject:
databases; programming; MySQL 5.5; MySQL 5.6; Professional MySQL; Learning MySQL; MySQL Reference; MySQL For Dummies; Definitive MySQL; MySQL Administration; MySQL In a Nutshell; MySQL Crash Course; MySQL Optimization; MySQL Workbench; tutorial; reference
Edition Description:
Trade paper
Publication Date:
20130431
Binding:
TRADE PAPER
Language:
English
Pages:
1176
Dimensions:
8.99 x 7.06 x 1.833 in 1742 gr

Related Subjects

Arts and Entertainment » Photography » Technique
Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Science and Mathematics » Mathematics » General

MySQL (Developer's Library) New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 1176 pages Addison-Wesley Professional - English 9780321833877 Reviews:
"Synopsis" by ,

This is the definitive, best-selling guide to using, programming, and administering MySQL 5.5, the newest version of the world's #1 open source database. Authored by Paul DuBois, the open source community leader who now leads MySQL's own English language documentation team, this guide is perfect for MySQL users at all levels of experience, in roles ranging from web developer to database administrator. Fully updated to reflect the final stable version of MySQL 5.5, MySQL, Fifth Edition has been meticulously revised and updated to cover important new features that extend MySQL's power and make it even more valuable in large-scale enterprise environments. Throughout, DuBois focuses on the productive and effective use of MySQL in real-world environments. DuBois covers all this: efficiently capturing information in a MySQL database, and formulating queries to retrieve it; using MySQL with PHP or Perl to generate dynamic web pages; writing programs that access MySQL databases; administering MySQL servers; controlling database access and enforcing security; maintaining, backing up, and replicating MySQL databases, and much more. This Fifth Edition incorporates extensive feedback from both readers and top developers throughout the MySQL global community, and also includes significantly expanded coverage of stored procedures, functions, triggers, and events.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.