The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Perl script to load text file into DB field Perl script to load text file into DB field
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Convert XML file into TEXT file using PERL seript Rudro Shell Programming and Scripting 0 06-11-2008 11:03 AM
Need help in wrting Load Script for a Load-Resume type of load. ankitgupta Shell Programming and Scripting 1 11-10-2006 12:46 AM
Shell Script to Load data into the database using a .csv file and .ctl file Csmani Shell Programming and Scripting 3 05-24-2006 09:09 AM
How to parse a text file with \034 as field and \035 as end of message delimiter? indianya Shell Programming and Scripting 1 08-26-2005 10:20 PM
Perl text file Sn33R Shell Programming and Scripting 5 10-31-2003 11:59 AM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 09-12-2008
aristegui aristegui is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 24
Perl script to load text file into DB field
Hello, maybe this post is offtopic, sorry for the inconveniencies (maybe should be in the forum with questions about C, C++, Java, SQL...).

I found examples about how to populate different fields from a text file (with MySQL, the LOAD DATA INFILE sentece), but not about how to load a complete plain text file into a concrete database field.

Could you please tell me if are available perl scripts/examples to implement something similar? maybe the best way is to insert an array with the text files contents in the choosen field, righ? any suggestions?

Thank you in advanced. Best regards.
  #2 (permalink)  
Old 09-13-2008
satheesh_ibm satheesh_ibm is offline
Registered User
  
 

Join Date: Apr 2008
Posts: 1
Can You try the following:
LOAD DATA INFILE "Filename"
INSERT INTO "tablename" ( Fieldname1 Position(1:n),.......)

Thanks
Shasi
HAL
  #3 (permalink)  
Old 09-15-2008
aristegui aristegui is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 24
Quote:
Originally Posted by satheesh_ibm View Post
Can You try the following:
LOAD DATA INFILE "Filename"
INSERT INTO "tablename" ( Fieldname1 Position(1:n),.......)

Thanks
Shasi
HAL
Hello, thankx for your help. The problem is that i would like to instert ALL the file content in a unique field, is this possible? how is the "trick"?

Best regards.
Closed Thread

Bookmarks

« "integer" in ksh? how to count with shell | add 2hours in current time »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 11:00 AM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0