MySQL增删改查小语句总结

alter table product add trusteefee varchar(45) DEFAULT NULL;

alter table product add administrativefee varchar(45) DEFAULT NULL;

// 为product表增加字段

alter table product drop column fixfee;

alter table product drop column bankfee;

// 删除product表字段

update product set trusteefee='0.1%' where id='1';

update product set administrativefee='0.1%' where id='1';

// 更新product表数据