create table T_Person (FName varchar(20),FAge int,FRemark varchar(20),primary key (FName))
–创建T_Person表,FName为主键
create table T_Debt (FNumber varchar(20),FAmount numeric(10,2) not null,FPerson varchar(20),primary key (FNumber),foreign key (FPerson) references T_Person(FName))
–创建T_Debt表,FNumber为主键,FAmount字段非空控制,T_Person表FName字段与T_Debt表FNumber字段为外键关联
insert into T_Person(FName,FAge,fremark) values('kevin','25','jiangsu')
–向T-Person表插入一笔数据
insert into T_Debt(fnumber,famount,fperson) values('001','5000.00','kevin')
–向T_Debt表插入一笔数据,FPerson字段外键约束自T_Person表FName字段(即FPerson字段想插入的数据kevin必须预先存在于T_Person表FName字段中)
update T_Person set fage='24',FRemark='shanghai' where FName='zerg'
–更新T_Person表FAge、FRemark字段
delete from T_Debt where FNumber='001'
–删除T_Debt表中FNumber字段为001的数据
drop table T_Debt
drop talbe T_Person
–删除T_Debt、T_Person表
发表于 2010-08-13 11:12
本来还想学学来的,看着这么多都吓到了!
[回复]