编辑代码

CREATE DATABASE Library;
use Library;
CREATE TABLE bookm (
	bid int,
	bname varchar(255),
	btype varchar(255),
	stock int
);
CREATE TABLE reader (
	rid int,
	rname varchar(255),
    sex enum('男','女'),
	subject1 varchar(255),
	borrownum int
);
CREATE TABLE publisher (
	pid int,
	pname varchar(255),
	address varchar(255),
	phone int
);
INSERT INTO bookm VALUES (1, '张三', '李四家隔壁', 1);
INSERT INTO bookm VALUES (1, '李四',  '张三家隔壁', 1);

SELECT * FROM bookm;