B站MySQL学习之job_grades表数据

CREATE TABLE job_grades
(grade_level VARCHAR(3),
lowest_sal INT,
highest_sal INT);

INSERT INTO job_grades VALUE ('A', 1000, 2999);
INSERT INTO job_grades VALUE ('B', 3000, 5999);
INSERT INTO job_grades VALUE ('C', 6000, 9999);
INSERT INTO job_grades VALUE ('D', 10000, 14999);
INSERT INTO job_grades VALUE ('E', 15000, 24999);
INSERT INTO job_grades VALUE ('F', 25000, 40000);

posted @ 2020-09-22 11:12  测试小风扇  阅读(325)  评论(0编辑  收藏  举报