ALTER TABLE trade_entry ADD for_delivery CHAR ( 1 ) DEFAULT ‘0’ AFTER waive_commission;
将数据库表中的一个可空字段修改为非空字段
1、UPDATE trade_entry SET for_deliveryE=‘默认值’ where COLUMNNAME IS NULL;
2、ALTER TABLE trade_entry MODIFY for_delivery VARCHAR2(300 CHAR) DEFAULT’ ’ NOT NULL;