4.8. Summary

Hopefully with the information in this chapter, you'll be able to go out and set up intricate database schemas, use complex queries, and maintain the whole system as well. Armed with these basic tools, there should be very few database obstacles you can't overcome. You might find in your role as a developer that you'll spend less time at a command-line interface, and more with tools such as PhpMyAdmin or MySQL AB's own MySQL Administrator GUI tool. The raw commands and queries you've seen in this chapter should be able to apply in any of these tools, as long as they have a way to enter raw commands. Your understanding of the exact SQL that performs your administrative and data-manipulative duties will also help you understand exactly what is going on behind any text fields, radio buttons, and checkboxes of a GUI MySQL application—or in your PHP application itself.

Get Professional LAMP: Linux®, Apache, MySQL®, and PHP5 Web Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.