TY - BOOK AU - Matthew, Neil : AU - Stones, Richard : TI - Beginning databases with MySQL SN - 1861006926 U1 - 005.7565 PY - 2002/// CY - Mumbai PB - Shroff Publishers. KW - SQL (Computer program language) KW - Relational databases N1 - "Programmer to programmer"--Cover. Includes index; Chapter 1 Introduction To MySQL 07 -- Chapter 2 Relational Database Principles 23 -- Chapter 3 Installing and Getting Started with MySQL 49 -- Chapter 4 Accessing Your Data 79 -- Chapter 5 MySQL Graphical Tools 119 -- Chapter 6 Changing Your Data 155 -- Chapter 7 Advanced Data Selection 179 -- Chapter 8 Data Definition and Manipulation 209 -- Chapter 9 Transactions and Locking 253 -- Chapter 10 MySQL Administration 279 -- Chapter 11 Database Design 311 -- Chapter 12 Accessing MySQL from C and C++ 341 -- Chapter 13 Accessing MySQL from PHP 385 -- Chapter 14 Accessing MySQL from Perl 425 -- Chapter 15 Accessing MySQL from Java 463 -- Chapter 16 Further Information and Resources 509 -- Appendix A MySQL Database Limits 517 -- Appendix B MySQL Data Types 521 -- Appendix C MySQL SQL Syntax 527 -- Appendix D mysql Reference 539 -- Appendix E Database Schema and Tables 543 -- Appendix F Large Objects Support in MySQL 547 N2 - MySQL is the world's most popular Open Source Relational Database designed for speed, power, and precision in heavy load use. MySQL AB is the company owned and run by the MySQL founders and main developers. MySQL offers the database programmer with a range of options and capabilities rarely seen in other database servers. MySQL runs under a broad array of operating systems. This book is a complete tutorial on MySQL features and functions and takes you through the whole process from installation and configuration of MySQL to executing commands and basic administration of the database server. We'll show you how to integrate MySQL with programming languages for the Web. What does this book cover? - Detailed tutorial in MySQL - Installing from binaries and source code on UNIX and Windows - Working with graphical tools - Various forms of queries, subqueries, aggregate functions, and joins - Discussion on transactions and locking - Performance monitoring, tuning, and server control - Connecting and executing SQL statements using C and C++ - Developing applications in PHP, Perl, and Java using MySQL ER -