Doing More with phpMyAdmin (Part 2) (
Page 1 of 7 )
In the first segment of this two-part tutorial, I gave you a quick overview of some of the interesting new features available in phpMyAdmin. In this concluding segment, find out how to use phpMyAdmin to define relationships between tables, maintain a log of commonly-used queries and create entity-relationship diagrams.In the first segment of this two-part tutorial, I gave you a quick overview of
some of the interesting new features available in phpMyAdmin. Starting with the
basics of the installation process and proceeding to the intricacies of securing
your instance of phpMyAdmin from prying eyes, changing the application's
appearance and using its built-in reporting features to obtain information on
who is using your MySQL RDBMS for what, I hope you're slowly realizing the
utility of this wonderful open-source tool. In fact, I'm going to stick my head
out and state that in my humble opinion, phpMyAdmin is to a MySQL developer what
TOAD is to an Oracle developer.
You might disagree with this - after
all, TOAD allows developers to model a database schema, perform step-by-step SQL
debugging and a whole lot more. In fact, that's the reason I came back for part
two - to convince skeptics such as yourself that phpMyAdmin is indeed a worthy
competitor, having added many useful features over the years.
Keep
reading to find out more.
