mysql——演示数据准备

灰太狼 2023-10-02 08:44 31阅读 0赞

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;