MySQL: The Complete Reference

Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest—and free—relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.

The Most Authoritative Resource on the MySQL Database Available! Reviewed by the MySQL Development Team.

Get the most out of the MySQL database server—today’s most popular open source database—with help from this definitive guide. Take advantage of MySQL’s cross-platform support, independent storage engines, advanced permissions and security system, query caching, full-text indexing and searching, and much more. Reviewed by the MySQL database development team, MySQL: The Complete Reference explains in full detail how to use this customizable RDMS to support robust, reliable, mission-critical applications.

• Install, configure, and test a MySQL database on Linux/UNIX or Windows
• Use MySQL data types, statements, operators, and functions
• Manage databases and tables with the Data Definition Language (DDL)
• Add, delete, and query records using the Data Manipulation Language (DML)
• Take advantage of transactional support
• Implement MySQL’s five-tiered access control and privilege system
• Handle database optimization, backup, recovery, and replication
• Create applications in C, C++, Perl, Java, PHP, and other languages

Vikram Vaswani is the founder and CEO of Melonfire, a company specializing in Web design, development, and content creation for a variety of clients. He has also written extensively on open source technologies, including MySQL, Perl, Python, and PHP.

Vikram Vaswani is the founder and CEO of Melonfire (http://www.melonfire.com/), a company specializing in software consultancy and content creation and syndication services. He is also the author of PHP Programming Solutions, How to do Everything with PHP and MySQL, and MySQL: The Complete Reference (all McGraw-Hill/Osborne titles) and XML and PHP (New Riders Publishing). He is also the author of numerous well-received articles on open-source technologies (including Perl, Python, XML and the very popular PHP 101 series), all written with the goal of making complex technologies accessible and understandable to novice users. He has been developing software since 1995, was first introduced to PHP in 1998, and hasn't looked back since. He is regular columnist with Zend Technologies (creators of PHP), as well as with IBM DeveloperWorks, CNET Builder.com, DevX.com and other OSS sites.