Article View: dk.edb.database
Article #15016Re: Mysql - Insert
From: Anders Hertz
Date: Fri, 20 Jul 2001 06:16
Date: Fri, 20 Jul 2001 06:16
16 lines
1493 bytes
1493 bytes
On Fri, 20 Jul 2001 00:28:33 +0200, "Kaare Christensen" <kaare@mermaidconsulting.com> wrote: > >Vil det sige at man godt kan s�tte flere "rows" ind p� en gang ved kun at >bruge en query? Umiddelbart kunne jeg ikke finde noget om dette i >manualen/p� internettet. mysql> INSERT INTO a VALUES (1,23),(2,34),(4,33); > >Det kunne for eksempel v�re en liste med 100 emails man skulle s�tte ind. >Vil det s� v�re muligt at g�re dette i 1 query (samtidig med at man kun >"connecter" en gang til databasen), istedet for i 100 forsk. queries? Kig n�rmere p� LOAD DATA INFILE.
Technical Details
Message-ID:
<3b57cc70.86920755@sunsite.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mailReferences:
<9j7mv8$1tr2$1@news.cybercity.dk>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,fcd64e0e2c76241b X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-07-19 23:19:25 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail From: ahz.ReMoVe@aub.auc.dk (Anders Hertz) Newsgroups: dk.edb.database Subject: Re: Mysql - Insert Date: Fri, 20 Jul 2001 06:16:44 GMT Organization: SunSITE.dk - Supporting Opensource Software Lines: 16 Message-ID: <3b57cc70.86920755@sunsite.dk> References: <9j7mv8$1tr2$1@news.cybercity.dk> NNTP-Posting-Host: umatic.aub.auc.dk X-Trace: sunsite.dk 995609964 26716 130.225.53.93 (20 Jul 2001 06:19:24 GMT) X-Complaints-To: news@sunsite.dk NNTP-Posting-Date: Fri, 20 Jul 2001 06:19:24 +0000 (UTC) X-Newsreader: Forte Free Agent 1.21/32.243 X-Authenticated: <anon>@<local>