9 messages in com.mysql.lists.javaLOAD DATA under jdbc
FromSent OnAttachments
alec...@quantel.com17 Aug 2001 08:04 
Kaarle Kaila17 Aug 2001 09:36 
Venu17 Aug 2001 10:16 
Mark Matthews17 Aug 2001 13:25 
Mark Matthews17 Aug 2001 15:53 
Venu17 Aug 2001 16:14 
Sinisa Milivojevic18 Aug 2001 04:48 
Michael Widenius18 Aug 2001 04:51 
Michael Widenius18 Aug 2001 05:01 
Subject:LOAD DATA under jdbc
From:alec...@quantel.com (alec@quantel.com)
Date:08/17/2001 08:04:03 AM
List:com.mysql.lists.java

Would LOAD DATA LOCAL work under jdbc? I want to create a temporary table of, perhaps, 100 rows by 40 columns. The data for the table is in memory. I am currently using INSERT INTO table VALUES (data...),(data...),. This is quite laborious to build, and involves quite a lot of parsing for MySQL. LOAD DATA is said to be faster. Obviously, I would have to write the data out to a scratch file and load in from it, but the result should be faster for large data sets.

Alec

<<-- This e-mail is intended for the named addressees only. Its contents may be privileged or confidential and should be treated as such. If you are not an intended recipient please notify the sender immediately; do not copy, distribute, or take any action based on this e-mail; and then delete it. In the pursuit of its legitimate business activities and its conformance with relevant legislation, Quantel Ltd. may access any e-mail (including attachments) it originates and receives, for potential scrutiny.

Version 10 of the Quantel Digital Factbook is now online - http://www.quantel.com/dfb