how to show type from table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gpong
Forum Newbie
Posts: 16
Joined: Sun Aug 06, 2006 8:49 am

how to show type from table

Post by gpong »

I have a problem with mySQL. I want to get the value from each field and its data type and also its default.
is there any command to show them?? help me please
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post by s.dot »

explain `tablename`
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
gpong
Forum Newbie
Posts: 16
Joined: Sun Aug 06, 2006 8:49 am

thanks

Post by gpong »

thank you very much its work very well
Post Reply