RE: [PHP-DB] how to change a column to ENUM

2002-04-07 Thread Gurhan Ozen
ossible 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 col

[PHP-DB] how to change a column to ENUM

2002-04-06 Thread andy
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