关于UPDATE 的用法(50分)

Z

Zero_Cool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-26

• #1

2个表分别为a , b

结构为：

a
id: integer;
Checked: boolean;

b
id: integer;
group_id: integer;

现在想写一条update 语句 将所有a 中所有a.id =b.id 并且b.group_id= 1 的纪录的
Checked 改为True;

请各位大虾赐教。

 

M

myghost9

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-26

• #2

update a set checked = true where b.group_id = 1 and id in (select id from b)

 

Z

Zero_Cool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-26

• #3

myghost9, 不行呀，按你所写的，执行后弹出异常，语法错误。

我用的是access 数据库，AdoQuery.

 

K

kevincsg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-26

• #4

update a set checked=true inner join b on (a.id=b.id) where b.group_id=1

 

K

K

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-26

• #5

关注

 

冰

冰火

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-27

• #6

试试这个：
update a set checked = true where id in (select id from b where b.group_id = 1)

 

Z

zhao0707

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-27

• #7

update a set checked = true where b.group_id = 1 and a.id in (select id from b)

 

Z

Zero_Cool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-28

• #8

都不行呀各位，还有没有可行的方法。
多谢各位了。

 

P

PLWang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-28

• #9

update a set checked = true where a.id in (select b.id from b where group_id=1)

 

C

cnaoszh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-30

• #10

用access的查询生成器自己试一试不就行了

 

T

TYZhang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-30

• #11

update `a set `checked = true where `id in (select `id from `b where `group_id=1)

 

Z

Zero_Cool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-30

• #12

自己搞定了，多谢各位的热心帮助，谢谢！！！