Using bash script : How to Import data from a dsv file into multiple tables in mysql Post: 303030993

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Import data from compressed file

HI I need to import data from a file which is in comressed format but system doesn't have enough space to uncompress file Is there any way so that i can do import from compressed file.

2. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:...

3. Shell Programming and Scripting

Data Import perl script

Hi, I have a requirement for creating a Perl Script which will perform Data Import process in an automated way and I am elaborating herewith : Section 1 ) - use the following command line format : "./import.pl -h hostname -p port -f datafile.txt" Section 2) datafile.txt will...

4. Shell Programming and Scripting

Reading data from multiple tables from Oracle DB

Hi , I want to read the data from 9 tables in oracle DB into 9 different files in the same connection instance (session). I am able to get data from one table to one file with below code : X=`sqlplus -s user/pwd@DB <<eof select col1 from table1; EXIT; eof` echo $X>myfile Can anyone...

5. Shell Programming and Scripting

Shell snip to import CSV data into BASH array

I have been trying to write a simple snip of bash shell code to import from 1 to 100 records into a BASH array. I have a CSV file that is structured like: record1,item1,item2,item3,item4,etc.,etc. .... (<= 100 items) record2,item1,item2,item3,item4,etc.,etc. .... (<= 100 items)...

6. Web Development

mysql query for multiple columns from multiple tables in a DB

Say I have two tables like below.. status HId sName dName StartTime EndTime 1 E E 9:10 10:10 2 E F 9:15 10:15 3 G H 9:17 10:00 logic Id devName capacity free Line 1 E 123 34 1 2 E 345 ...

7. Shell Programming and Scripting

Bash script with python slicing on multiple data files

I have 2 files generated in linux that has common output and were produced across multiple hosts with the same setup/configs. These files do some simple reporting on resource allocation and user sessions. So, essentially, say, 10 hosts, with the same (2) system reporting in the files, so a...

8. Shell Programming and Scripting

Append data by looking up 2 tables for multiple files

I want to lookup values from two different tables based on common columns and append. The trick is the column to be looked up is not fixed and varies , so it has to be detected from the header. How can I achieve this at once, for multiple data files, but lookup tables fixed. The two lookup...

9. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop...

10. Shell Programming and Scripting

Shell script automation using cron which query's MySQL Tables

What I have: I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory) note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates...

LEARN ABOUT DEBIAN

time::warp

Warp(3pm)						User Contributed Perl Documentation						 Warp(3pm)

NAME

       Time::Warp - control over the flow of time

SYNOPSIS

	   use Time::Warp qw(scale to time);

	   to(time + 5);  # 5 seconds ahead
	   scale(2);	  # make time flow twice normal

DESCRIPTION

       Our external experience unfolds in 3 1/2 dimensions (time has a dimensionality of 1/2).	The Time::Warp module offers developers control
       over the measurement of time.

API

       o   to($desired_time)

	   The theory of relativity asserts that all physical laws are enforced relative to the observer.  Since the starting point of time is
	   arbitrary, it is permissable to change it.  This has the effect of making it appear as if time is moving forwards or backward
	   instanteously.  For example, on some types of operating systems time starts at Wed Dec 31 19:00:00 1969 (this will likely change as we
	   approach 2030 and with the acceptance of 64-bit CPUs).

	     to(time + 60*60);	     # 1 hour ahead

       o   scale($factor)

	   Changes the speed at which time is progressing.

	     scale(scale * 2);	 # double the speed of time

	   Note that it is not possible to stop time or cause it to reverse since this is forbidden by the second law of thermodynamics.

ALSO SEE

       Time::HiRes and Event.

SUPPORT

       Please direct your insights or complaints to perl-loop@perl.org.

DISCLAIMER

       THIS SOFTWARE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
       MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  THIS IS NOT A TIME MACHINE.  THIS MODULE CANNOT BE USED TO VIOLATE THE SECOND LAW OF
       THERMODYNAMICS.

COPYRIGHT

       Copyright X 1999, 2000 Joshua Nathaniel Pritikin.  All rights reserved.	This program is free software; you can redistribute it and/or
       modify it under the same terms as Perl itself.

perl v5.14.2							    2000-08-02								 Warp(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Import data from compressed file

Discussion started by: ap_gore79

2. Shell Programming and Scripting

Converting tables of row data into columns of tables

Discussion started by: justthisguy

3. Shell Programming and Scripting

Data Import perl script

Discussion started by: scott_apc

4. Shell Programming and Scripting

Reading data from multiple tables from Oracle DB

Discussion started by: net