INSERT data to a Database Table from a text file

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Intelligent Script to Insert Records in Database Table

Hello All Members, I am new to this forum and to the shell scripting. I want to write a shell script to do the following: Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the...

2. Shell Programming and Scripting

How to read a text file line by line and insert into a database table?

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....

3. Programming

Need help on Insert data to mySQL database

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....

4. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

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.

5. UNIX for Dummies Questions & Answers

Bash script to insert data into an html table

hi, I need to create a bash shell script which picks up data from a text file and in the output file puts it into an html made table. I have to use sed and awk utilties to do this the input text file will contain data in the format: job name para1 para2 para3 para4 para4 1 ...

6. Shell Programming and Scripting

load a data from text file into a oracle table

Hi all, I have a data like, 0,R001,2,D this wants to be loaded into a oracle database table. Pl let me know how this has to be done. Thanks in advance

7. Shell Programming and Scripting

how to insert data into database by reading it from a text file??

Hi....can you guys help me out in this script?? Below is a text file and it contains these: GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL005675 000001...

8. Shell Programming and Scripting

How to insert data into MYSql database from a text file

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...

9. Shell Programming and Scripting

ccall database and collect data from one table

I want to connect to one database and collect data from any table using shell script.

10. Shell Programming and Scripting

how to insert data in database based on text file?

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 ...

LEARN ABOUT DEBIAN

mysql::diff::table

MySQL::Diff::Table(3pm) 				User Contributed Perl Documentation				   MySQL::Diff::Table(3pm)

NAME

       MySQL::Diff::Table - Table Definition Class

SYNOPSIS

	 use MySQL::Diff::Table

	 my $db = MySQL::Diff::Database->new(%options);
	 my $def	   = $db->def();
	 my $name	   = $db->name();
	 my $field	   = $db->field();
	 my $fields	   = $db->fields();		   # %$fields
	 my $primary_key   = $db->primary_key();
	 my $indices	   = $db->indices();		   # %$indices
	 my $options	   = $db->options();

	 my $isfield	   = $db->isa_field($field);
	 my $isprimary	   = $db->isa_primary($field);
	 my $isindex	   = $db->isa_index($field);
	 my $isunique	   = $db->is_unique($field);
	 my $isfulltext    = $db->is_fulltext($field);

DESCRIPTION

       Parses a table definition into component parts.

METHODS

   Constructor
       new( %options )
	   Instantiate the objects, providing the command line options for database access and process requirements.

   Public Methods
       Fuller documentation will appear here in time :)

       o   def

	   Returns the table definition as a string.

       o   name

	   Returns the name of the current table.

       o   field

	   Returns the current field definition of the given field.

       o   fields

	   Returns an array reference to a list of fields.

       o   primary_key

	   Returns a hash reference to fields used as primary key fields.

       o   indices

	   Returns a hash reference to fields used as index fields.

       o   options

	   Returns the additional options added to the table definition.

       o   isa_field

	   Returns 1 if given field is used in the current table definition, otherwise returns 0.

       o   isa_primary

	   Returns 1 if given field is defined as a primary key, otherwise returns 0.

       o   isa_index

	   Returns 1 if given field is used as an index field, otherwise returns 0.

       o   is_unique

	   Returns 1 if given field is used as unique index field, otherwise returns 0.

       o   is_fulltext

	   Returns 1 if given field is used as fulltext index field, otherwise returns 0.

COPYRIGHT AND LICENSE

       Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       mysqldiff, MySQL::Diff, MySQL::Diff::Database, MySQL::Diff::Utils

AUTHOR

       Adam Spiers <mysqldiff@adamspiers.org>

perl v5.14.2							    2012-04-06						   MySQL::Diff::Table(3pm)

Web Development