搜题
问题   更新时间2023/7/3 22:14:00

创建表offices和employees,写出创建语句;(8分)

CREATE TABLE offices ( Office_code int(10) not null, city varchar(50), address varchar(50), country varchar(50), postal_code varchar(15) PRIMARY KEY (office_code) ); CREATE TABLE employees ( Employee_number INT(10) NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50), mobile VARCHAR(25), office_code INT(10), job_title VARCHAR(50), note VARCHAR(255), gender VARCHAR(5), );
王老师:19139051760(拨打)