以下内容均为转载,仅为学习记录,谢谢原作者们的分享!
parts表:
create table if not exists parts( part_id smallint(6) not null, part_name varchar(6) not null, part_mail varchar(6) not null, part_pass varchar(20) not null, primary key(part_id), foreign key(part_name) references books(book_borrower) on delete cascade on update cascade) engine=InnoDB character set utf8 collate utf8_general_ci;
books表:
create table if not exists books(book_id smallint(6) not null auto_increment, book_name char(20) not null, book_pic varchar(200) not null, book_author char(20) not null, book_pub char(40) not null, book_sort char(6) not null, book_owner char(6) not null, book_borrower char(7) not null, book_borrower_time date default null, primary key(book_id), index(book_borrower)) engine=InnoDB character set utf8 collate utf8_general_ci auto_increment=5;
parts表即part_name字段为外键,关联到books表的book_borrower字段,删除books表中的数据,在parts表中与之关联的数据也会被删除;反之,删除parts表中的数据,books表中数据不会受到影响,依然存在。(on delete cascade)
mysql -P + 端口名
mysql 数据库名 -u 用户名 -p