insert into member (intDepartmentID,strName) values (5,'张山') where (select count(*) from member where intDepartmentID=5 and strName!='张山')=0
stWalking 说的 insert into member (intDepartmentID,strName) values (5,'张山') where (select count(*) from member where intDepartmentID=5 and strName!='张山')=0 不行hongyanyufei:说的,是在sqlserver中的语句,我的数据库是mysql
主键: alter table member add primary key(intDepartmentID,strName); 唯一限制索引: alter table member add unique emp_name2(intDepartmentID,strName);
where (select count(*) from member where intDepartmentID=5 and strName!='张山')=0
insert into member (intDepartmentID,strName) values (5,'张山')
where (select count(*) from member where intDepartmentID=5 and strName!='张山')=0 不行hongyanyufei:说的,是在sqlserver中的语句,我的数据库是mysql
alter table member add primary key(intDepartmentID,strName);
唯一限制索引:
alter table member add unique emp_name2(intDepartmentID,strName);