Search This Blog

Friday, May 13, 2011

MySQL how to add a new column/field in a table

MySQL how to add a new column/field in a table

ALTER TABLE table_name ADD coupon_new_column DATETIME

e.g.

ALTER TABLE coupons_coupons ADD coupon_expiredate DATETIME

No comments: