1.创建数据库company,在库中创建两个表offices和employees表
CREATE DATABASE company;
CREATE TABLE offices
(
officeCode INT(10) PRIMARY KEY AUTO_INCREMENT, #主键从功能上看相当于非空且唯一所以定义为主键即不用再定义非空和唯一
city VARCHAR(50) NOT NULL,
address VARCHAR(50),
country VARCHAR(50) NOT NULL,
postalCode VARCHAR(15) UNICODE
);
CREATE TABLE employees
(
employeeNumber INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
lastName VARCHAR(50) NOT NULL,
firstName VARCHAR(50) NOT NULL,
mobile VARCHAR(50) UNICODE,
officeCode INT(10) NOT NULL ,
jobTitle VARCHAR(50) NOT NULL,
birth DATETIME NOT NULL,
note VARCHAR(255),
sex VARCHAR(5),
CONSTRAINT office_fk FOREIGN KEY(officeCode) REFERENCES offices(officeCode)
);
#2.查看该库底下几个表