1.product表
CREATE table product(
id INT(10) PRIMARY KEY NOT NULL,
name VARCHAR(20) NOT NULL,
function VARCHAR(50) DEFAULT NULL ,
company VARCHAR(20) NOT NULL,
address VARCHAR(50) DEFAULT NULL
);
1.medicine表
CREATE table medicine(
id INT(10) PRIMARY KEY NOT NULL,
name VARCHAR(20) NOT NULL,
function VARCHAR(50) DEFAULT NULL,
company VARCHAR(20) NOT NULL,
address VARCHAR(50) DEFAULT NULL
);
INSERT INTO medicine VALUES
而过热