外键案例
mysql> create table 员工表(
员工编号 int primary key auto_increment,
员工姓名 char(5) )charset=utf8 engine=innodb;
mysql> create table 工资表(
工资编号 int,员工名 char(5),
工资 double,
foreign key(工资编号) references 员工表(员工编号)
on update cascade
on delete cascade
)charset utf8 engine=innodb;
mysql> insert into 员工表 values(“丽丽”),(“梅梅”);
ERROR 1136 (21S01): Column count doesn’t match value count at row 1
mysql> insert into 员工表(员工姓名) values(“丽丽”),(“梅梅”);
mysql> insert into 工资表 values(“1”,“丽丽”,“7880.65”),(“2”,“梅梅”,“9500.55”);
mysql> desc 员工表;
mysql> desc 工资表;
mysql> select * from 员工表;
mysql> select * from 工资表;