MySQL in 21 Days

MySQL is the most widely installed open-source database. Approximately 3.5 million MySQL servers are in use and more than 45% of databases used on Linux worldwide are MySQL databases.
Its latest version, MySQL 4.1 closes the gap between MySQL and other, more sophisticated databases. Version 4.1 permits the use of MySQL as an embedded database, which means it can be compiled into another application and used in a range of devices.
The second edition of Sams Teach Yourself MySQL in 21 Days has been completely rewritten by a new author. The book enables a reader to create powerful databases using MySQL. He willnot only learn how to integrate MySQL into a database-driven Web site, but also how to embed MySQL into other compiled applications.

• Day 1. Introduction to MySQL.
• Day 2. Installing MySQL.
• Day 3. Getting Started with Database Design.
• Day 4. Getting Hands-On with MySQL.
• Day 5. MySQL Data Types.
• Day 6. Manipulating a Database.
• Day 7. Inserting and Updating Data.
• Day 8. Querying Data.
• Day 9. Joins and Indexes.
• Day 10. Operators and Functions in MySQL.
• Day 11. Using PHP.
• Day 12. Using the Perl DBI.
• Day 13. Using the C API.
• Day 14. Security.
• Day 15. Administration.
• Day 16. Repair and Maintenance.
• Day 17. Transactions and Table Locking.
• Day 18. Optimizing Performance.
• Day 19. Replication.
• Day 20. Embedding the MySQL Server.
• Day 21. Extending MySQL s Function Library.
• Appendix A. Data Type Reference.
• Appendix B. SQL Reference.
• Appendix C. Function and Operator Reference.
• Appendix D. The PHP API.