Article View: cn.bbs.comp.database
Article #1085Re: �ʸ�sql��������
From: ��������24��~˭�ɽ���ޱ�
Date: Wed, 23 Apr 2008 13:58
Date: Wed, 23 Apr 2008 13:58
24 lines
1875 bytes
1875 bytes
����Թ��ˣ�Ҳ���� �ҿ���������˵�� update 1 set 1.A=2.C from 1 join 2 on 1.B=2.D �����ˣ�Ҳ���С����� �ڴ���˽�� �� �� Len (��������) �Ĵ������ᵽ: �� : msҪ�и�from��. : updata 1 set 1.A=2.c where 1.B=2.D from 1,2 : sql�Լ����Ǻܶ� : �� �� Durini (��������24��~˭�ɽ���ޱ�) �Ĵ������ᵽ: �� : : ��������1��2����1���������A��B����2���������C��D������Ҫ���±�1��A=C����� : : D��ֵ��B : : ��������д�� : : update 1 set 1.A=2.C where 1.B=2.D; : : ���ִ��� �����㣬�ڴ���2 : : ����һ�������ʲô���⣿ -- �������Ѿ����ӣ�Ů������ֻ�а��� http://bbs.sjtu.edu.cn/file/Inter/111841225728620.jpg [m[1;34m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.36.158][m
Technical Details
Message-ID:
<4ZZXcK$baZ@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news2.arglkargh.de!news.mixmin.net!news.netcologne.de!newsfeed-fusi2.netcologne.de!news.isoc.lu!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,83483d7c238d2318 X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news2.arglkargh.de!news.mixmin.net!news.netcologne.de!newsfeed-fusi2.netcologne.de!news.isoc.lu!news.shec6.edu.cn!SJTU From: Durini.bbs@bbs.sjtu.edu.cn (��������24��~˭�ɽ���ޱ�) Newsgroups: cn.bbs.comp.database Subject: Re: �ʸ�sql�������� Date: 23 Apr 2008 13:58:24 GMT Organization: ��ˮ˼Դ Message-ID: <4ZZXcK$baZ@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1208959028.A