mysql——演示数据准备

最新推荐文章于 2026-01-06 23:45:00 发布

原创最新推荐文章于 2026-01-06 23:45:00 发布 · 72 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #数据库 #sql #oracle #sqlserver

本文详细介绍了一系列SQL数据库操作，包括创建数据库、使用数据库、创建表、插入数据及查询数据的具体实现。通过实例展示了如何构建和填充两个不同的表以及一个员工与部门的关联表，为读者提供了实用的SQL操作指南。

create database see;

use database see;
=========================================================================================

create table cr01 ( sx int(50),
                    mz varchar(50),
                    bz varchar(50)
                   );


insert into cr01 ( sx,mz,bz ) values (1,'sww','sww01');

insert into cr01 values (2,'aww','aww02');

insert into cr01 values (3,'qww','qww03'),
                        (4,'eww','eww04'),
                        (5,'rww','rww05');

insert into cr01 ( sx,mz,bz ) values (6,'yww','yww06'),
                                     (7,'uww','uww07');

select * from cr01;

==============================================================================


create table cr02 ( sx02 int(50),
                    mz02 varchar(50),
                    bz02 varchar(50)
                   );


insert into cr02 ( sx02,mz02,bz02 ) values (8,'iww','iww08');

insert into cr02 ( sx02,mz02,bz02 ) values (9,'oww','oww09');

insert into cr02 ( sx02,mz02,bz02 ) values (10,'zww','zww10');

select * from cr02;


=======================================================================================



create table employee ( num int(50),
                        d_id int(50),
                        name varchar(50),
                        age int(50),
                        sex varchar(50),
                        homeadd varchar(50)
                       );


insert into employee values(1,1001,'zhangsan',26,'nan','beijing');
insert into employee values(2,1001,'lisi',24,'nv','hunan');
insert into employee values(3,1002,'wangwu',25,'nan','jiangsu');
insert into employee values(4,1004,'aric',15,'nan','yingguo');

select * from employee;




create table department ( d_id int(50),
                          d_name varchar(50),
                          functione varchar(50),
                          address varchar(50)
                        );

insert into department values(1001,'keyanbu','yanfachanpin','3lou5hao');
insert into department values(1002,'shengchanbu','shengchanchanp','5louyiceng');
insert into department values(1003,'xiaoshoubu','cehuaxiaoshou','1louxiaoshoudating');



select * from employee;

select * from department;