Re: ��INSERT��ʲô��⣿��

Article View: cn.bbs.comp.database

Article #8432

Back to cn.bbs.comp.database Previous Next

#8432

From: ��˹ȵ�С��
Date: Fri, 21 Nov 2003 02:35

34 lines
2350 bytes

��������mysql������
----------------------------------------------------------
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
        [INTO] tbl_name [(col_name,...)]
        VALUES ((expression | DEFAULT),...),(...),...
        [ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
or  INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
        [INTO] tbl_name [(col_name,...)]
        SELECT ...
or  INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
        [INTO] tbl_name
        SET col_name=(expression | DEFAULT), ...
        [ ON DUPLICATE KEY UPDATE col_name=expression, ... ]

----------------------------------------------------------
����sql serverò��Ҳ��֧��
������ֻ��һ��һ��дinsert��
�డ��

�� �� minnow (���˹ȵ�С���) �Ĵ������ᵽ: ��
: ����
: age ��varchar�͵ģ�������'5'��д��û�������
: �� �� minnow (���˹ȵ�С���) �Ĵ������ᵽ: ��
: : INSERT INTO selfadd(ID,NAME,AGE) 
: :  (TABLE (1, 'aa','5'),
: :          (2, 'bb','6')) 
: : MYSQL��ʾ��"(TABLE......)"�������﷨����
: : �ѵ�mysql��֧��sql2��


--
��������----
          �����Ѿ����ˣ�:(    
[m[1;34m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 211.80.44.159][m

Technical Details

Message-ID: <49LTO0$b4d@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-out1.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!news-out.cwix.com!newsfeed.cwix.com!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!ngpeer.news.aol.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,GB
X-Google-Thread: 101948,d0ad9381b5e031c2
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-11-20 18:36:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-out1.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!news-out.cwix.com!newsfeed.cwix.com!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!ngpeer.news.aol.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU
From: minnow.bbs@bbs.sjtu.edu.cn (���˹ȵ�С���)
Newsgroups: cn.bbs.comp.database
Subject: Re: ����INSERT�����ʲô���⣿��
Date: 21 Nov 2003 02:35:06 GMT
Organization: ��ˮ˼Դ
Message-ID: <49LTO0$b4d@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1069382016.A

Article View: cn.bbs.comp.database

Re: ����INSERT�����ʲô���⣿��

Re: ��INSERT��ʲô��⣿��