2019121610280

DROP DATABASE IF EXISTS Hospital;
CREATE DATABASE Hospital;
USE Hospital;

CREATE TABLE Doctor
(
	id INT PRIMARY KEY AUTO_INCREMENT,
	NAME VARCHAR(20) NOT NULL,
	age INT NOT NULL,
	major VARCHAR(20) NOT NULL
);

INSERT INTO Doctor VALUES (NULL,'张三',30,' 骨科');
INSERT INTO Doctor VALUES (NULL,'李四',35,'心血管');
INSERT INTO Doctor VALUES (NULL,'王五',40,'妇产科');

SELECT * FROM Doctor;