ENUM Datatype error

[vineet]

hi all

i have a table name product_table in my database. i want to add a field name "status" in "product_table" after "warranty" field with ENUM datatype values ("Y,"N").
I m getting the following error when writing in qry in sql field or adding the field by choosing values and datatype manually.


SQL query:

ALTER TABLE product_table ADD COLUMN status TYPE ENUM( "Y", "N" ) AFTER warranty

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE ENUM ("Y", "N") AFTER warranty' at line 1

[NXArmada]

try this:



ALTER TABLE `product_table` ADD `status` ENUM( 'Y', 'N' ) AFTER `warranty`;