JK Web Studio is a small web design studio, specializing in efficient and user friendly solutions.

Contact us at info@jkwebstudio.com

Changing ENUM values

ALTER TABLE db.table_name CHANGE COLUMN old_column_name new_column_name ENUM(’first’,’second’,'third’) NOT NULL DEFAULT ‘first’;

Leave a Reply