Tuesday, February 15, 2011

mysql add enum column

mysql> alter table user_cart add cart_type enum('favorite','order') DEFAULT 'favorite';

mysql> alter table user_cart add add_time timestamp not null default CURRENT_TIMESTAMP;

No comments:

Post a Comment