how to change a column to ENUM
| From: | andy | Date: | Sat, 06 Apr 2002 12:18:23 +0000 |
| Subject: | how to change a column to ENUM | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18271@lists.php.net to get a copy of this message | ||
Hi there,
I did just do a procedure anlyse to my table and figured out that the best
type would be enum.
I tryed:
ALTER TABLE
test CHANGE field field ENUM
but I am getting an error: You have an error at your sql sytax at ""
Is this column type even possible, because I have over 2million entries,
while the field has only 250 different values.
Is this type really faster? Currently my structure looks like this:
id medium_int(9)
field1 char50
field2 char2
field3 char2
Field 1 contains about 1.5 million different entries.
Thanx for any help,
Andy