Linux Today: Linux News On Internet Time.

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. "

Complete Story

Related Stories: