Hi Andy, That statement won't work because you have to provide the possible values for the enum colummn. Say you can only have Y or N or that field, that you need to type:
ALTER TABLE `test` CHANGE `field` `field` ENUM('Y','N'); By the way, if you have 250 different possible entries , I would say not to go with ENUM, but then again it is all depend on you, and your company's policies. Gurhan -----Original Message----- From: andy [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 7:18 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] how to change a column to ENUM 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php