SQL——学习之路

最新推荐文章于 2025-06-11 18:33:42 发布

五彩的星空

最新推荐文章于 2025-06-11 18:33:42 发布

阅读量282

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/start155/article/details/80063782

本文介绍如何使用SQL语句创建数据库及表格，并演示了向部门表和雇员表插入数据的具体操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、首先建库、搭建表，搭建练习的环境。

1、建库建表

--create database company

create database company

use company

2、创建表--部门表 create table dept(deptno int(3) primary key,danme varchar (14) ,loc varchar(13));

--往部门表中查数据 insert into dept values(10,'Accounting','New York'); insert into dept values(20,'Research','Dallas'); insert into dept values(30,'Sales','Chicago'); insert into dept values(40,'Operations','Boston'); insert into dept values(50,'Admin','Washing');
--往雇员表中插数据 insert into emp values(7369,'Smith','Clerk',7902,'1980-12-17',800,0,20); insert into emp values(7499,'Allen','Salesman',7698,'1981-2-20',1600,300,30); insert into emp values(7844,'Turner','Salesman',7499,'1981-9-8',1500,0,30); insert into emp values(7698,'Tom','Manager',0,'1981-9-8',6100,600,40); insert into emp values(7876,'Adams','Clerk',7900,'1987-5-23',1100,0,20); insert into emp values(7900,'James','Clerk',7698,'1981-12-3',2400,0,30); insert into emp values(7902,'Ford','Analyst',7698,'1981-12-3',3000,null,20); insert into emp values(7901,'Kik','Clerk',7900,'1981-12-3',1900,0,30);