(三)在Navicat中,利用Query对表删除,创建,插入操作

ゞ浴缸里的玫瑰 2022-05-26 23:14 131阅读 0赞

/\*  
此文章,建立在以下两篇基础上  
\*/

\#\#\#\#\#在Query中输入:(删除表)

drop table if exists TB_Student;
    drop table if exists TB_Class;

\#\#\#\#\#在Query中输入:(创建TB\_Class表,TB-Student表)

create table TB_Class
    (
       ClassID              int not null,
       ClassName            varchar(20) not null,
       Descript             varchar(200),
       primary key (ClassID)
    );
    create table TB_Student
    (
       StudentID            int not null auto_increment,
       ClassID              int not null,
       StudentName          varchar(20) not null,
       Birth                date not null,
       Degree               varchar(10),
       CardID               varchar(20),
       City                 varchar(20),
       Salary								float,
       Descript             varchar(200),
       primary key (StudentID)
    );

\#\#\#\#\#在Query中输入:(插入数据)

delete from TB_Student;
    
    delete from TB_Class;
    
    insert into TB_Class (ClassID, ClassName, Descript) values (1, 'S114', 'a best team');
    
    insert into TB_Class (ClassID, ClassName, Descript) values (2,'S207', 'good');
    
    insert into TB_Class (ClassID,ClassName, Descript) values (3,'S209', 'excellent');
    
    insert into TB_Class (ClassID,ClassName, Descript) values (4,'S115', 'i don\'t know');
    
    insert into TB_Class (ClassID, ClassName, Descript) values (5,'S116', 'rookie');
    
    
    insert into TB_Student ( ClassID, StudentName, Birth, Degree, CardID, City,Salary, Descript) values ( 1, 'Yao', '1980-8-11', 'Master', 'XY9NY7VHNCE5PDB4NOCR', 'shanghai', 1500.3,'good');
    
    insert into TB_Student ( ClassID, StudentName, Birth, Degree, CardID, City, Salary,Descript) values ( 2, 'howard', '1985-3-3', 'bachelor', 'M7ICSC2G2P2KJ2X74Q1D', 'houston',500, 'dirty');
    
    insert into TB_Student (ClassID, StudentName, Birth, Degree, CardID, City, Salary,Descript) values ( 3, 'alston', '1981-1-1', 'bachelor', 'EPSJQTV0FB9WRSVJ173J', 'new York',1500, 'responsible');
    
    insert into TB_Student ( ClassID, StudentName, Birth, Degree, CardID, City,Salary, Descript) values ( 1, 'head', '1981-1-1', 'bachelor', 'AXHGRAJ00SY4AC6GRQYR', 'utah', 1000,'big mouth');
    
    insert into TB_Student ( ClassID, StudentName, Birth, Degree, CardID, City,Salary, Descript) values ( 2, 'kobe', '1981-1-1', 'bachelor', 'HOG55TFWJJM8BMETH4SE', 'texas', 851,'humor');
    
    insert into TB_Student (ClassID, StudentName, Birth, Degree, CardID, City, Salary,Descript) values ( 2, 'tracy', '1981-1-1', 'doctor', 'WL85G7YWWTKLCD9J0SRT', 'washington',850, 'black sheep');
    
    insert into TB_Student ( ClassID, StudentName, Birth, Degree, CardID, City,Salary, Descript) values ( 3, 'kib', '1981-1-1', 'bachelor', 'LWCQREDBWBU2Y IP7F3C', 'kansas', 120,'stingy');
    
    insert into TB_Student ( ClassID, StudentName, Birth, Degree, CardID, City,Salary, Descript) values ( 1, 'gosol', '1981-1-1', 'master', '5IPNV6NGEWLIPYFQXHXM', 'indiana', 1450,'adapterble');
    
    insert into TB_Student (ClassID, StudentName, Birth, Degree, CardID, City,Salary, Descript) values ( 4, 'carter', '1981-1-1', 'master', 'MRG9UQU1BKGHVNT 7H3O', 'hawaii',1300, 'stable');
    
    insert into TB_Student ( ClassID, StudentName, Birth, Degree, CardID, City, Salary,Descript) values ( 2, 'tim', '1981-1-1', 'bachelor', '9AAQUBQ4B5OYVLD6X2OE', 'Alaska', 1000,'smart');