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

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

在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');