62,072
社区成员
发帖
与我相关
我的任务
分享sql语句 看看哪儿错了
insert into member(M_ID,M_pwd,M_email) values('liu','123456','') where 'liu' not in (select M_ID from member)
...全文
请发表友善的回复…
发表回复
weiyong922 2007-01-18
- 打赏
- 举报
:)
liuxin001 2007-01-18
- 打赏
- 举报
3楼已经给你答案了
paoluo 2007-01-18
- 打赏
- 举报
樓上寫的有些問題.
有兩種寫法：
1.
If Not Exists(Select M_ID from member Where M_ID = 'liu')
insert into member(M_ID,M_pwd,M_email) values('liu','123456','')
2.
insert into member(M_ID,M_pwd,M_email) Select 'liu','123456',''
Where Not Exists (Select M_ID from member Where M_ID = 'liu')
有兩種寫法：
1.
If Not Exists(Select M_ID from member Where M_ID = 'liu')
insert into member(M_ID,M_pwd,M_email) values('liu','123456','')
2.
insert into member(M_ID,M_pwd,M_email) Select 'liu','123456',''
Where Not Exists (Select M_ID from member Where M_ID = 'liu')
pcgenius 2007-01-17
- 打赏
- 举报
IF EXISTS(SELECT * FROM member WHERE M_ID='luias')
insert into member(M_ID,M_pwd,M_email) values('luias','355129','')
insert into member(M_ID,M_pwd,M_email) values('luias','355129','')
pcgenius 2007-01-17
- 打赏
- 举报
IF EXISTS(SELECT * FROM member)
insert into member(M_ID,M_pwd,M_email) values('luias','355129','')
insert 怎么能用WHERE. 严重错误.
insert into member(M_ID,M_pwd,M_email) values('luias','355129','')
insert 怎么能用WHERE. 严重错误.
