Title: Beginning MySQL Author(s): Robert Sheldon, Geoff Moes Pages: 864 Publisher: Wrox Publication date: 2005 Language: English Format: PDF ISBN-10: 0764579509 ISBN-13: Description: As the most popular open source database system in the world, MySQL boasts ease of implemen-tation, minimal overhead, consistent reliability, and low total cost of ownership. This hands-on resource offers you a complete look at MySQL and explains how to implement MySQL and access MySQL with various programming languages.
Written for experienced programmers who develop applications that access backend data-bases, this guide explains how to install MySQL 4.1 on Linux and Windows platforms, create a MySQL database, query and manage data in that data-base, and connect to the database from PHP, Java, and ASP.NET applica-tions. The authors also discuss transactions, system variable settings, the access privilege system, performance optimization, and backing up a database.
By the end of the book you'll have a solid foundation for understanding MySQL as a robust, flexible, and easy-to-implement application that has many diverse uses.
- Provides programmers with a complete foundation in MySQL, the multi-user, multi-threaded SQL database server that easily stores, updates, and accesses information
- Offers detailed instructions for MySQL installation and configuration on either Windows or Linux
- Shows how to create a database, work with SQL, add and modify data, run queries, perform administrative tasks, and build database applications
- Demonstrates how to connect to a MySQL database from within PHP, Java, ASP, and ASP.NET applications
- Companion Web site includes SQL statements needed to create and populate a database plus three ready-to-use database applications (in PHP, Java, and ASP.NET)