Article View: dk.edb.database
Article #15015Mysql - Insert
From: Kaare Christensen
Date: Thu, 19 Jul 2001 22:28
Date: Thu, 19 Jul 2001 22:28
27 lines
1931 bytes
1931 bytes
Hej edb.database Her er lige et lille MySQL sp�rgsm�l/problem som jeg ikke helt forst�r. I deres manualen under ( http://www.mysql.com/doc/I/n/Insert_speed.html ) st�r der flg.: ---------------------------------- [klip] * If you are inserting many rows from the same client at the same time, use multiple value lists INSERT statements. This is much faster (many times in some cases) than using separate INSERT statements. [klip] ---------------------------------- 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. 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? -- Mvh. K�re Christensen http://www.mermaidconsulting.com
Technical Details
Message-ID:
<9j7mv8$1tr2$1@news.cybercity.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!skynet.be!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.cybercity.dk!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,fcd64e0e2c76241b,start X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-07-19 15:29:02 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!skynet.be!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.cybercity.dk!not-for-mail From: "Kaare Christensen" <kaare@mermaidconsulting.com> Newsgroups: dk.edb.database Subject: Mysql - Insert Date: Fri, 20 Jul 2001 00:28:33 +0200 Organization: CyberCity Internet Lines: 29 Message-ID: <9j7mv8$1tr2$1@news.cybercity.dk> NNTP-Posting-Host: 217.157.88.114 X-Trace: news.cybercity.dk 995581736 63330 217.157.88.114 (19 Jul 2001 22:28:56 GMT) X-Complaints-To: abuse@cybercity.dk NNTP-Posting-Date: Thu, 19 Jul 2001 22:28:56 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200