homepage Welcome to WebmasterWorld Guest from 54.205.173.252
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Viewing MySql table
View table
Adam5000




msg:4204444
 9:00 pm on Sep 20, 2010 (gmt 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!

 

topr8




msg:4204469
 9:38 pm on Sep 20, 2010 (gmt 0)

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!

Adam5000




msg:4205568
 3:01 am on Sep 23, 2010 (gmt 0)

topr8: Thank you for your reply and that sounds like a good idea.

rocknbil




msg:4205874
 3:59 pm on Sep 23, 2010 (gmt 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.

Anyango




msg:4213952
 7:51 pm on Oct 8, 2010 (gmt 0)

phpMyAdmin ? phpmyadmin.net

Demaestro




msg:4213981
 9:21 pm on Oct 8, 2010 (gmt 0)

you can execute this query and output the results.

show columns in tablename;

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved