【MySQL第五次作业】

1.作业要求

2.触发器

2.1 建立两个表（goods orders）

mysql> use mydb16_trigger;
Database changed
mysql> create table goods
    -> (gid char(8) primary key,
    -> name varchar(10),
    -> price decimal(8,2),
    -> num int);

mysql> create table orders
    -> (oid int primary key auto_increment,
    -> gid char(10) not null,
    -> name varchar(10),
    -> price decimal(8,2),
    -> onum int,
    -> otime date);

<