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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to