[SOLVED] mysql adding status field with enum datatype

[vinpkl]

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 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 

 

vineet

[fenway]

Rmove the word "TYPE".