Page 1 of 1

how to show type from table

Posted: Wed Sep 05, 2007 8:26 pm
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

Posted: Wed Sep 05, 2007 8:42 pm
by s.dot
explain `tablename`

thanks

Posted: Wed Sep 05, 2007 8:52 pm
by gpong
thank you very much its work very well