Welcome to WebmasterWorld Guest from 54.166.55.74

Forum Moderators: open

Message Too Old, No Replies

Viewing MySql table

View table

   
9:00 pm on Sep 20, 2010 (gmt 0)

10+ Year Member



Greetings all

I'm trying to create a table in a MySql database using PHP and I think I've done it. But I'm not sure.

Is there a way to view the table after it's created? At this point it's empty but I think it's there.

Help!
9:38 pm on Sep 20, 2010 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



why don't you install MySQL workbench - which is part of the MySQL package.

it is perfect for looking at databases, testing queries etc - also for what you want!
3:01 am on Sep 23, 2010 (gmt 0)

10+ Year Member



topr8: Thank you for your reply and that sounds like a good idea.
3:59 pm on Sep 23, 2010 (gmt 0)

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member




Is there a way to view the table after it's created?


Execute

describe table (tablename);

without () You'll have to loop through files and rows, but this will give you the raw output.
7:51 pm on Oct 8, 2010 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



phpMyAdmin ? phpmyadmin.net
9:21 pm on Oct 8, 2010 (gmt 0)

WebmasterWorld Senior Member demaestro is a WebmasterWorld Top Contributor of All Time 10+ Year Member



you can execute this query and output the results.

show columns in tablename;
 

Featured Threads

Hot Threads This Week

Hot Threads This Month