Home » Open Source » MySQL » File data without -INFILE
File data without -INFILE [message #565391] Tue, 04 September 2012 04:03 Go to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Hi Guys,
i need small help on mysql script to load the csv file without using the "INFILE" as below like.

How to load the data without using "INFILE" option.
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3)


Thanks,
Re: File data without -INFILE [message #566416 is a reply to message #565391] Fri, 14 September 2012 05:55 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Help me?
Re: File data without -INFILE [message #566419 is a reply to message #566416] Fri, 14 September 2012 06:33 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you know, we mostly deal with Oracle and not many regulars use MySQL. Maybe you'd have better luck on one of dedicated MySQL forums.
Re: File data without -INFILE [message #566420 is a reply to message #566419] Fri, 14 September 2012 06:52 Go to previous message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Thank lot..
Previous Topic: way to inserting data into a MYSQL table data in an ordered way
Next Topic: Date validation in mysql
Goto Forum:
  


Current Time: Mon Mar 18 23:27:53 CDT 2024