Welcome to WebmasterWorld Guest from 54.144.114.177

Forum Moderators: open

Message Too Old, No Replies

Viewing MySql table

View table

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

Preferred Member

10+ Year Member

joined:Apr 1, 2005
posts:369
votes: 0


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 Sept 20, 2010 (gmt 0)

Senior Member

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

joined:Apr 19, 2002
posts:3171
votes: 8


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 Sept 23, 2010 (gmt 0)

Preferred Member

10+ Year Member

joined:Apr 1, 2005
posts:369
votes: 0


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

Senior Member

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

joined:Nov 28, 2004
posts:7999
votes: 0



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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Apr 24, 2005
posts:697
votes: 0


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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 15, 2003
posts:2606
votes: 0


you can execute this query and output the results.

show columns in tablename;
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members