View Single Post

   
  #5 (permalink)  
Old 02-28-2008, 10:45 AM
lark
 
Posts: n/a
Default Re: how to determine column type

Willem Bogaerts wrote:
>> Could someone please tell me how I might determine the column type (char
>> vs. integer is good enough) if I know the column name?

>
> If you are doing so from PHP, there is a separate function for that. In
> SQL, the command:
>
> SHOW FIELDS FROM <table name>
>
> Will get you the column details.
>
> Best regards,


shorter version of show fields is desc <table name> if you'd like to
save time by typing less.

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".
Reply With Quote