This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / mysql里面这个update句子如何写？ update table_a set field_a=(select field_b from table_b where table_a.field_c=table_b.field_d); 谢谢
-lord_of_ring(魔王转世);
2004-2-18
(#1610344@0)
-
update table_a set field_a = table_b.field_b from table_a, table_b where table_a.field_c=table_b.field_d
-meisme(我就是我);
2004-2-18
(#1610380@0)
-
syntax error : (
-lord_of_ring(魔王转世);
2004-2-18
(#1610544@0)
-
update table_a set field_a=('select field_b from table_b where table_a.field_c=table_b.field_d');
-canadiantire(ct);
2004-2-18
(#1610557@0)
-
I am kidding, MySQL seems not support subselect yet. at least 4.0.16.
-canadiantire(ct);
2004-2-18
(#1610562@0)