Get the Most Out of phpMyAdmin's Visual Query Designer
Jun 02, 2011, 17:08 (0 Talkback[s])
[ Thanks to Lee Schlesinger for this link. ]
"Why use a tool like phpMyAdmin when you can study
tables and type up queries by hand? Because that process is prone
to error. You may not know what fields are used as keys in the
database tables, you may mistype field names in your table joins
and select lists, and, if you use a number of relational database
management systems, each of which uses a slightly different flavor
of SQL, you may trip against crucial differences in syntax.
"Software tools like phpMyAdmin help by examining the table
structure for you, presenting the list of field names grouped by
tables, and marking indexed fields. "