try using "SHOW FIELDS FROM TABLE LIKE EXPR", where 'TABLE' is the
name of the name of the table, and 'EXPR' is an expression indicating what
you wish to match.
for example, to get the information about a column called 'ckey' in table
'config', you would do: "SHOW FIELDS FROM CONFIG LIKE 'CKEY'".
hope this helps.
~shawn
On Mon, 13 Aug 2001, Matthew Marcus wrote:
>
> Hello,
>
> Having trawled through the documentation for a while I'm none the wiser -
> is there any way of retrieving the data type of a single column using
> MySQL? Any suggestions would be most appreciated.
>
> Thanks,
>
> Matthew Marcus
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
