CREATE DATEBASE zhangsa_library_ab;
USE zhangsan_library_ab; CREATE TABLE book(
bid INT PRIMARY KEY,
bname VARCHAR(50),
author VARCHAR(30),
pricr FLOAT,
pub-date DATE
);
CREATE TABLE reader(
rid INT PRIMARY KEY,
rname VARCHAR(20),
phone VARCHAR(11),
rtype VARCHAR(10)
);
CREATE TABLE borrow(
id INT PRIMARY KEY AUTO_INCREMENT,
rid INT,
bid INT,
borrow_date DATE, return_date DATE
);
