You know the conventional wisdom on MySQL: trusty little database, great for web applications, speedy, reliable, and you can’t beat the price. But (there’s always a but!) without crucial features like transactions, definitely not enterprise-ready. Well, with the long-awaited 4.x upgrades, the MySQL people are finally dealing with that last objection -- which means this already popular package is likely to spread even more rapidly. Whether your application is grassroots or pinstripes, read SAMS Teach Yourself MySQL in 24 Hours and you’ll be ready.
Julie Meloni walks you through all the bread-and-butter tasks you’ll want to master with MySQL 4.0, including transactions (though stored procedures, moved back to 4.1, isn’t here yet). She starts with the absolute basics: simple database design; using the MySQL client; creating and populating your database tables; selecting, modifying, and deleting data. Gradually, you’ll build your skills; first modifying table structures, then using MySQL’s many built-in functions in your queries.
There’s a full section on administering your MySQL server, covering optimization, tuning, backup, and restore. And, for the programmers among us, complete introductions on using MySQL with both Perl and PHP. With this book, you’re a lot closer to mastering MySQL than you thought. (Bill Camarda)
Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.