OraFAQ Forum: MySQL » File data without -INFILE

Home » Open Source » MySQL » File data without -INFILE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

File data without -INFILE [message #565391]

Tue, 04 September 2012 04:03

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,

Report message to a moderator

Re: File data without -INFILE [message #566416 is a reply to message #565391]

Fri, 14 September 2012 05:55

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Help me?

Report message to a moderator

Re: File data without -INFILE [message #566419 is a reply to message #566416]

Fri, 14 September 2012 06:33

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: File data without -INFILE [message #566420 is a reply to message #566419]

Fri, 14 September 2012 06:52

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Thank lot..

Report message to a moderator

Previous Topic:	way to inserting data into a MYSQL table data in an ordered way
Next Topic:	Date validation in mysql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:24:15 CST 2024