1.
(1)
mysql> use mydb16_trigger;
Database changed
mysql> create table goods(
->gid char(8) primary key,
->name varchar(10),
->price decimal(8,2),
->num int);
Query OK,0 rows affected(0.01 sec)
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);
Query OK,0 rows affected (0.01 sec)
(2)
mysql> insert into goods values('A0001','橡皮',2.5,100),
->('B0001','小楷本',2.8,210),
->('C0001','铅笔',1.2,120),
->('D0001','计算机',28,20);
Query OK,4 rows affected(0.00 sec)
(3)
3.