mySQL Question - How to view contents of table?

[wizzz]

After I create a table called 'foo' and insert some data into it,
how can I view the data stored in 'foo'?

I'd appreciate any help.

 

[ScottMac]

select * from foo

Then you can do a select * from foo order by field, field

or

select field1, field3, ....fieldN from foo

Replace "field" with a real field name in foo.

show structure will show the fields and what kind of data they are

Good Luck

Scott