create table debarkation -- 1 用户登录表
(
uid int identity(1,1), -- 用户编号
uname varchar(50) primary key , -- 用户名
Upasswrod varchar(50) not null, -- 密 码
popedomid int constraint popedomid_fk foreign key (popedomid) references popedom (popedomid) --权限ID
)
create table popedom -- 权限表
(
popedomid int primary key, -- 权限ID
popedomname varchar(50)not null ,-- 权限名称
popedomtypeid int constraint popedomtypeid_ff foreign key (popedomtypeid) references popedomtypeid (popedomtypeid) -- 权限类型)create table popedomtypeid --类型表
(
popedomtypeid int primary key,
popedomtypename varchar(50)not null) insert popedom values(1,'超级管理员',1)
insert debarkation values('zmzmzm258','tm5244817',1)
insert popedomtypeid values(1,'添加,发布,审核,修改')
我现在要同时更新数据怎么操作
修改
(
uid int identity(1,1), -- 用户编号
uname varchar(50) primary key , -- 用户名
Upasswrod varchar(50) not null, -- 密 码
popedomid int constraint popedomid_fk foreign key (popedomid) references popedom (popedomid) --权限ID
)
create table popedom -- 权限表
(
popedomid int primary key, -- 权限ID
popedomname varchar(50)not null ,-- 权限名称
popedomtypeid int constraint popedomtypeid_ff foreign key (popedomtypeid) references popedomtypeid (popedomtypeid) -- 权限类型)create table popedomtypeid --类型表
(
popedomtypeid int primary key,
popedomtypename varchar(50)not null) insert popedom values(1,'超级管理员',1)
insert debarkation values('zmzmzm258','tm5244817',1)
insert popedomtypeid values(1,'添加,发布,审核,修改')
我现在要同时更新数据怎么操作
修改
(
uid int identity(1,1), -- 用户编号
uname varchar(50) primary key , -- 用户名
Upasswrod varchar(50) not null, -- 密 码
popedomid int constraint popedomid_fk foreign key (popedomid) references popedom (popedomid) ON UPDATE CASCADE--权限ID
)
create table popedom -- 权限表
(
popedomid int primary key, -- 权限ID
popedomname varchar(50)not null ,-- 权限名称
popedomtypeid int constraint popedomtypeid_ff foreign key (popedomtypeid) references popedomtypeid (popedomtypeid) ON UPDATE CASCADE -- 权限类型)create table popedomtypeid --类型表
(
popedomtypeid int primary key,
popedomtypename varchar(50)not null)