MySQL (Developer's Library Series)
Search in google:
The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1MySQL is an open source relational database management system 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.In MySQL, Paul DuBois provides a comprehensive guide to using and administering MySQL effectively and productively. He 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 fourth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.0, as well as to add new coverage of features introduced with MySQL 5.1.“One of the best technical books I have read on any subject.”–Gregory Haley, C Vu, The Association of C & C++ Users“A top-notch user’s guide and reference manual, and in my opinion, the only book you’ll need for the daily operation and maintenance of MySQL databases.”–Eugene Kim, Web TechniquesIntroduction 1Part I: General MySQL UseChapter 1: Getting Started with MySQL 13Chapter 2: Using SQL to Manage Data 101Chapter 3: Data Types 201Chapter 4: Stored Programs 289Chapter 5: Query Optimization 303Part II: Using MySQL Programming InterfacesChapter 6: Introduction to MySQL Programming 341Chapter 7: Writing MySQL Programs Using C 359Chapter 8: Writing MySQL Programs Using Perl DBI 435Chapter 9: Writing MySQL Programs Using PHP 527Part III: MySQL AdministrationChapter 10: Introduction to MySQL Administration 579Chapter 11: The MySQL Data Directory 585Chapter 12: General MySQL Administration 609Chapter 13: Access Control and Security 699Chapter 14: Database Maintenance, Backups, and Replication 737Part IV: AppendixesAppendix A: Obtaining and Installing Software 777Appendix B: Data Type Reference 797Appendix C: Operator and Function Reference 813Appendix D: System, Status, and User Variable Reference 889Appendix E: SQL Syntax Reference 937Appendix F: MySQL Program Reference 1037Note: Appendixes G, H, and I are located online and are accessible either by registering this book at informit.com/register or by visiting www.kitebird.com/mysql-book. Appendix G: C API Reference 1121Appendix H: Perl DBI API Reference 1177Appendix I: PHP API Reference 1207Index 1225 Library Journal MySql is a very popular relational database for a number of reasons: it is free for most applications; while not open source it is heavily used by the open source community; and it runs easily on Windows and UNIX. The author's approach is to use two sample databases to explain SQL (structured query) databases with Perl, PHP, and C; administering MySql; and security. This book will be very popular with users who already understand relational databases and are trying to move from Microsoft or Oracle to MySql. Copyright 2000 Cahners Business Information.\\
Introduction 1I General MySQL Use1 Getting Started with MySQL 132 Using SQL to Manage Data 1013 Data Types 2014 Stored Programs 2895 Query Optimization 303II Using MySQL Programming Interfaces6 Introduction to MySQL Programming 3417 Writing MySQL Programs Using C 3598 Writing MySQL Programs Using Perl DBI 4359 Writing MySQL Programs Using PHP 527III MySQL Administration10 Introduction to MySQL Administration 57911 The MySQL Data Directory 58512 General MySQL Administration 60913 Access Control and Security 69914 Database Maintenance, Backups, and Replication 737IV AppendixesA Obtaining and Installing Software 777B Data Type Reference 797C Operator and Function Reference 813D System, Status, and User Variable Reference 889E SQL Syntax Reference 937F MySQL Program Reference 1037G C API Reference 1121H Perl DBI API Reference 1177I PHP API Reference 1207Index 1225
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
