9 messages in com.mysql.lists.javaRe: LOAD DATA under jdbc| From | Sent On | Attachments |
|---|---|---|
| alec...@quantel.com | 17 Aug 2001 08:04 | |
| Kaarle Kaila | 17 Aug 2001 09:36 | |
| Venu | 17 Aug 2001 10:16 | |
| Mark Matthews | 17 Aug 2001 13:25 | |
| Mark Matthews | 17 Aug 2001 15:53 | |
| Venu | 17 Aug 2001 16:14 | |
| Sinisa Milivojevic | 18 Aug 2001 04:48 | |
| Michael Widenius | 18 Aug 2001 04:51 | |
| Michael Widenius | 18 Aug 2001 05:01 |
| Subject: | Re: LOAD DATA under jdbc |
|---|---|
| From: | Mark Matthews (mmat...@thematthews.org) |
| Date: | 08/17/2001 01:25:59 PM |
| List: | com.mysql.lists.java |
LOAD DATA LOCAL does not work under JDBC, as this feature is implemented by the MySQL client.
The non-local version of this does work, if you can get the data file to somewhere the server can read it from.
-Mark
----- Original Message ----- From: <alec...@quantel.com> To: <Ja...@lists.mysql.com> Sent: Friday, August 17, 2001 10:04 AM Subject: LOAD DATA under jdbc
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
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.