软件开发培训班 >> 编程开发 >> SQL


SQL学习笔记二 创建表、插入数据的语句

　　本文标签：创建表,插入数据

创建一个表T_Employee并插入若干数据
复制代码 代码如下:

create table T_Employee(FNumber VARCHAR(20),FName VARCHAR(20),FAge int,FSalary NUMERIC(10,2) ,PRIMARY KEY(FNumber));
insert into T_Employee(FNumber,FName,FAge,FSalary) values(DEV001,Tom,25,8300);
insert into T_Employee(FNumber,FName,FAge,FSalary) values(DEV002,Jerry,28,2300.80);
insert into T_Employee(FNumber,FName,FAge,FSalary) values(SALES001,John,23,5000);
insert into T_Employee(FNumber,FName,FAge,FSalary) values(SALES002,Kerry,28,6200);
insert into T_Employee(FNumber,FName,FAge,FSalary) values(SALES003,Stone,22,1200);
insert into T_Employee(FNumber,FName,FAge,FSalary) values(HR001,Jane,23,2200.88);
insert into T_Employee(FNumber,FName,FAge,FSalary) values(HR002,Tina,25,5200.36);
insert into T_Employee(FNumber,FName,FAge,FSalary) values(IT001,Smith,28,3900);
insert into T_Employee(FNumber,FAge,FSalary) values(IT002,27,2800);


大家可以查找下 create与insert命令的使用 。