Visual Quickstart Guide MySQL

I. In the midst of the Information Age, where more and more data is being stored on computers, the need for high-speed, reliable databases has increased dramatically. For years, large companies, such as Oracle, Microso...

Chapter 1. Installing MySQL Obviously the first thing you'll need to do to begin using MySQL is install the software. But because MySQL is anopen-source database application, you have more options when it comes to insta...

Chapter 2. Running MySQL Now that the MySQL software has been successfully installed (presumably), it's time to learn how to start, stop, and basically administer your database server. Assuming that you did not install...

Chapter 3. Database Design Whenever you are working with a relational database management system such as MySQL, the first step in creating and using a database is to establish its structure. Database design, aka data mo...

Chapter 4. Creating a MySQL Database In Chapter 3, quot;Database Design,quot; I went through the steps involved in coming up with your database scheme, a process called normalization. Those concepts apply to any relatio...

Chapter 5. Basic SQL SQL, short for Structured Query Language (although this is sometimes debated), is a group of special words used exclusively for interacting with databases. Every major database uses SQL, and MySQL i...

Chapter 6. MySQL Functions MySQL has dozens of built-in functions that are designed to simplify common tasks. I'll cover the most useful ones here, but don't be surprised if you find that MySQL has added others in newer...

Chapter 7. MySQL and PHP PHP and MySQL have been used together for years, and the combination has improved the popularity of both technologies. PHP now supports two different sets of MySQL functions. The original, mysql...

Chapter 8. MySQL and Perl Long before PHP came along as a major player in Web development, programmers were using Perl (Practical Extraction and Report Language) for system management and Web applications alike. Perl wa...

Chapter 9. MySQL and Java Over the past several years, Java has emerged as a very popular programming language, thanks largely to its platform independence. You can use Java to create applets that run on Web pages, to w...

Chapter 10. Advanced SQL and MySQL Chapter 5, quot;Basic SQL,quot; and Chapter 6, quot;MySQL Functions,quot; discuss the fundamentals of both technologies. In those chapters I focus on the commands and functions that wi...

Chapter 11. MySQL 5 Features With each new major release of MySQL, often-requested features have been added. Many of these features have been present in rival database applications for years, although, to be fair, not s...

Chapter 12. Techniques for Programming This, the fourth and final programming chapter of the book, will show you some specific ways of using programming languages to interface with MySQL. Whereas chapters 7 through 9 de...

Chapter 13. MySQL Administration There are several facets to administering a MySQL server, from the obvious and critical backing up of data to improving security and performance. Fortunately the reliability of MySQL dem...