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;