Article View: cn.bbs.comp.database
Article #1853Re: ��ҿ����ҵ�SQL����IJ��ԣ�
From: ��������
Date: Fri, 21 Oct 2005 14:03
Date: Fri, 21 Oct 2005 14:03
27 lines
1826 bytes
1826 bytes
������
Update ��1 a set a.�ֶ�1 = (select b.�ֶ�2 from ��2 b where b.id = a.id )
�� �� Risingsun (����) �Ĵ������ᵽ: ��
: �� ��: ��ҿ����ҵ�SQL����IJ��ԣ�
: ����վ: BBS ���Ļ�����վ (Thu Oct 13 07:53:21 2005)
:
: ���õ�powerbuilder,���ӵ�oralce��ݿ⣬���������˵��ִ�б���select * from
: �?
: ���������Ҳ�֪����ôȥ�������ˣ����磺update ��1 set �ֶ�1=b.�ֶ�2 from ��1 a,
: ��2 b where a.id=b.id;
: ��Ұ��ҿ���������Ĵ��˰���
: --
: 2005������һ���ҵ
:
:
: [m[33m�� ��Դ:�����Ļ����� http://bbs.cqupt.edu.cn��[FROM: bbs.cqupt.edu.cn][m
--
[1;33m[3I ��Ҳû����֪������
[m[1;36m�� ��Դ:�����Ļ����� bbs.cqupt.edu.cn��[FROM: 220.113.96.178][m
Technical Details
Message-ID:
<4KefJS$be2@bbs.cqupt.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!nntp-server.pubsub.com!bbsnews.sdu.edu.cn!news.uestc.edu.cn!CQUPTShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,ef1a6b6268cd6960,start X-Google-Attributes: gid101948,public X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!nntp-server.pubsub.com!bbsnews.sdu.edu.cn!news.uestc.edu.cn!CQUPT From: xuanzi@bbs.cqupt.edu.cn-SPAM.no (��������) Newsgroups: cn.bbs.comp.database Subject: Re: ��ҿ����ҵ�SQL����IJ��ԣ� Date: 21 Oct 2005 14:03:01 GMT Organization: ���Ļ����� Message-ID: <4KefJS$be2@bbs.cqupt.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: DataBase/M.1129903276.V0 Lines: 27