Viewing MySql table

View table

[Adam5000]

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]

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]

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

[rocknbil]

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]

phpMyAdmin ? phpmyadmin.net

[Demaestro]

you can execute this query and output the results.

show columns in tablename;