MySQL Forums
Forum List  »  Perl

problem with LOAD FILE INFILE in perl script
Posted by: mad bu
Date: October 06, 2006 12:51PM

Hi all,

I am new to perl and mysql. I want to load bulk data from a text file to mysql tables thru perl script. I am able to use 'insert' statements in perl and could solve my problem , but if i use 'insert' it is taking lot of time to load bulk data, so i want to use LOAD FILE in perl script can anyone help me with the syntax of LOAD FILE .... in perl script.

Tx in advance,
Mad_bu.



Edited 1 time(s). Last edit at 10/06/2006 12:59PM by mad bu.

Options: ReplyQuote


Subject
Written By
Posted
problem with LOAD FILE INFILE in perl script
October 06, 2006 12:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.