Linux DB PHP Scripts Tech Diary
Search This Blog
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;
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)