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;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment