homepage Welcome to WebmasterWorld Guest from 54.205.207.53
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Viewing MySql table
View table
Adam5000

5+ Year Member



 
Msg#: 4204442 posted 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

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



 
Msg#: 4204442 posted 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

5+ Year Member



 
Msg#: 4204442 posted 3:01 am on Sep 23, 2010 (gmt 0)

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

rocknbil

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



 
Msg#: 4204442 posted 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

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4204442 posted 7:51 pm on Oct 8, 2010 (gmt 0)

phpMyAdmin ? phpmyadmin.net

Demaestro

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



 
Msg#: 4204442 posted 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.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved