View Full Version : Veiwing Database Contents?

12-14-2006, 02:07 PM
Hello everyone...
due to my horrible memory, i have created a table in my database and cant remember the colum names in the table.
is there any way to view this information, any mysql command-line command or php function?

I have 2 tables so far, named "login" and "boxxertrumps" in my DB "blog"

Thanks for your time/help...

12-14-2006, 02:19 PM
Check out the MySQL GUI Tools (http://dev.mysql.com/downloads/gui-tools/5.0.html)

MySQL Administrator will help you out as well as the Query browser.

12-14-2006, 10:03 PM
any mysql command-line command
explain login;

01-04-2007, 07:34 AM
or use phpmyadmin

01-04-2007, 04:13 PM
I don't recommend it. One gets a much better feel for the database using the command-line client.

01-20-2007, 03:46 PM
phpmyadmin is good though if you can't/don't want to download the 50mb package for the command-line client.