On Wednesday 22 August 2001 16:14, you wrote:
> is there a way in Perl/DBI to select the possible values of a set or
> enum type? this can't be dependant on on querying actual records, but
> querying the data itself. Of course this is outside of doing a desc and
> parsing the output information in my code itself. but more like:
>
> select possibilities
> from table.field
>
> Then fetch that into an array/arrayref...
SHOW COLUMNS FROM table_name LIKE 'field_name';
parse the output.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
---------------------------------------------------------------------
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
