A complete, authoritative reference on the MySQL database server Written by a MySQL expert, this book contains extensive information on the latest version of the world's most popular open-source database. MySQL Database Usage & Administration provides comprehensive coverage of all topics related to MySQL deployment, from installation to data backup and optimization. Information on workplace deployment and development on the MySQL architecture is also included.
Country of Publication:
16 December 2009
Professional and scholarly
Part I: Usage; Chapter 1. An Introduction to MySQL; Chapter 2. Understanding Basic Commands; Chapter 3. Making Design Decisions; Chapter 4. Using Joins, Subqueries, and Views; Chapter 5. Using Transactions; Chapter 6. Using Stored Procedures and Functions; Chapter 7. Using Triggers and Scheduled Events; Chapter 8. Working with Data in Different Formats; Chapter 9. Optimizing Performance; Part II: Administration; Chapter 10. Performing Basic Server Administration; Chapter 11. Managing Users and Controlling Access; Chapter 12. Performing Maintenance, Backup, and Recovery; Chapter 13. Replicating Data; Appendix A. Installing MySQL and the Sample Database; Index
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.