Hey there,
first off all, please CC me any replies, as I'm no longer a member of the
list... Sorry about that but I just receive too much... Over 2000 emails a
day is no exception and I can no longer keep track of them.
Ok, for the problem, I want to list the possible values of a enum variable.
In the manual it says:
If you want to get all possible values for an ENUM column, you should use:
SHOW COLUMNS FROM table_name LIKE enum_column_name and parse the ENUM
definition in the second column.
I have a database called RMA with a table called test with a enum in there
called Var.
Here comes a paste from my mysql client.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 3.23.40
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use RMA;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> describe test;
+-------+---------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type
| Null | Key | Default | Extra |
+-------+---------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Var | enum('Omgeruild - RMA Stock','Omgeruild - DOA','Credit
Nota','Defect Gevonden','Out Of Warranty') | YES | | NULL | |
+-------+---------------------------------------------------------------------------------------------------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> SHOW COLUMNS FROM test LIKE Var;
ERROR 1064: You have an error in your SQL syntax near 'Var' at line 1
This manual is from 3.23.39 and I'm using 3.23.40, that shouldn't be an issue
right? So what am I doing wrong here?? :-(
I need it for PHP, so it can create a html dropdown box with those values....
Kind regards,
Ferry van Steen
---------------------------------------------------------------------
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
