At 12:09 AM 11/28/2009, Krishna Chandra Prajapati wrote:
Hi Mos,
In the below two command does 1 is faster than 2.
1. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;
2. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet LINES TERMINATED
BY '\r\n' enclosed by '"';
Thanks,
Krishna
Hi Mos,
In the below two command does 1 is faster than 2.
*
1. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;*
2. *LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet* *LINES
TERMINATED BY '\r\n' enclosed by '"';*
Thanks,
Krishna Ch. Prajapati
On Sat, Nov 28, 2009 at 3:50 AM, mos
At 07:40 AM 11/27/2009, Krishna Chandra Prajapati wrote:
Hi Experts,
load data local infile and insert into are the two methods of
inserting data into a mysql table.
Out of the above two method. Is there any faster method of inserting data
into mysql tables.
No. Load Data is the fastest meth
Hi Experts,
load data local infile and insert into are the two methods of
inserting data into a mysql table.
Out of the above two method. Is there any faster method of inserting data
into mysql tables.
Thanks,
Krishna Ch. Prajapati
Hello all. This is a snippet from my JavaBean that I'm using to insert data
into MySql database.
The bean is working perfectly alright but I can't insert data into the user
table. Please help and do tell what I'm doing wrong here.
This is the code:
public String saveToDB() {
try {
Class.for
