|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
how to insert data into database by reading it from a text file??
Post 302252719 by pallavishetty on Thursday 30th of October 2008 07:30:40 AM
10-30-2008
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a text file script....called Bukom.txt and it contains these:
BUKOM 20060101 2.5 2.6 2.7 2.8 2.9 2.3 2.1
BUKOM 20060102 2.4 2.5 2.6 2.7 2.7 2.6 2.4
BUKOM 20060103 2.1 ... (9 Replies)
Discussion started by: forevercalz
9 Replies
2. Shell Programming and Scripting
Hi,
Need to get help from you guys about this issue.
I need to insert data into MySql database from a text file which is located in other server.
The text file is something look like below:
Date | SubscriberNo | Call Duration
20/7/07 | 123456788 | 20
20/7/07 | 123412344 | 30
The... (4 Replies)
Discussion started by: shirleyeow
4 Replies
3. Shell Programming and Scripting
hello,
I have got the following problem that I am hoping someone can help with please.
1. I have got the following text file (below) , the columns data are
'Test Day', 'Board', 'Betting Number'.
TEXT FILE
============================================
1 3 02-01-27-28-29-30
0 1... (1 Reply)
Discussion started by: jermaine4ever
1 Replies
4. Shell Programming and Scripting
Hello,
I have a problem which is giving me headache for days, can some please help. Please see code and text fiel below. Please see text in red for the problem I am facing
# Program gets an input x from user
while read line ; do
echo... (4 Replies)
Discussion started by: jermaine4ever
4 Replies
5. Shell Programming and Scripting
Hi All,
Please help me in writing data to a file in one row.
In database there is a column which contains large data which does not fit in the file in one row. The column contains list of paths. I want to write these paths to a file in one row.
Please find the code below writes :
... (2 Replies)
Discussion started by: rajeshorpu
2 Replies
6. Web Development
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
Discussion started by: sitex
0 Replies
7. Shell Programming and Scripting
Hi,
I have below type of data in a text file in unix.
Emp_Name Emp_Dept
Raj 101
Amruta 100
Shilpa 100
Rohit 123
Amol 198
Rosh 101
Gaurav 198
Number of employees can be even more.
Need a command or a... (2 Replies)
Discussion started by: rajneesh_kapoor
2 Replies
8. Shell Programming and Scripting
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Discussion started by: shellguy
15 Replies
9. Programming
Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies
10. Shell Programming and Scripting
I have a test file that I want to read and insert only certain lines into the
the table based on a filter.
1. Rread the log file 12 Hours back Getdate() -12 Hours
2. Extract the following information on for lines that say "DUMP is
complete"
A. Date
B. Database Name
C.... (2 Replies)
Discussion started by: JolietJake
2 Replies
LEARN ABOUT DEBIAN
eiskaltdcpp-daemon
eiskaltdcpp-daemon(1) General Commands Manual eiskaltdcpp-daemon(1) NAME
eiskaltdcpp-daemon - simple daemon controllable via XMLRPC or JSONRPC SYNOPSIS
eiskaltdcpp-daemon -d eiskaltdcpp-daemon <Key> DESCRIPTION
EiskaltDC++ is a cross-platform program that uses the Direct Connect and ADC protocol. It is compatible with other DC clients, such as the original DC from Neomodus, DC++ and derivatives. EiskaltDC++ also interoperates with all common DC hub software. COMMAND LINE OPTIONS
A summary of options is included below. -d,--daemon" Run program as daemon -v,--verbose" Verbose mode -D,--debug" Debug mode -P <port>,--port=<port>" Set port for XMLRPC or JSONRPC (default: 3121) -L <ip>,--ip=<ip>" Set IP address for XMLRPC or JSONRPC (default: 127.0.0.1) -p file,--pidfile=<file>" Write daemon process ID to <file> -c dir,--confdir=<dir>" Store config in <dir> -l <dir>,--localdir=<dir>" Store local data (cache, temp files) in <dir> (defaults is equal confdir) -S <file>,--rpclog=<file>" Write xmlrpc log to <file> (default: /tmp/eiskaltdcpp-daemon.xmlrpc.log) -U <uripath>,--uripath=<uripath>" Set UriPath for xmlrpc abyss server to <uripath> (default: /eiskaltdcpp) -h, --help Display help and exit -V, --version Show version information and exit FILES
~/.config/eiskaltdc++/ or $XDG_CONFIG_HOME/eiskaltdc++/ Directory with user configuration files DOCUMENTATION
Detail documentation about available XMLRPC and JSONRPC methods can be found in our wiki: http://code.google.com/p/eiskaltdc/wiki/XMLRPC http://code.google.com/p/eiskaltdc/wiki/JSONRPC AUTHOR
This program was written by EiskaltDC++ developers team (see file AUTHORS). EiskaltDC++ homepage: http://code.google.com/p/eiskaltdc/ BUG REPORTS
If you find a bug in EiskaltDC++ please report it here: http://code.google.com/p/eiskaltdc/issues/list This manual page was written by Boris Pek <tehnick-8@mail.ru> for the Debian project (and may be used by others). 19 Feb 2012 eiskaltdcpp-daemon(1)