Populate SQL-table: resource(s) with shell scripts

[Ladyluck]

I am interested in obtaining/writing a simple script which will populate a table in a database (SQLite or MySQL) with data from a text file. The text file contains several lines of data with many individual values per line.
I thought it would be easy to find scripts on the

http://www I

could use as templates or general guidelines but my googling has been unsuccessful.
A pointer to a useful resource will be much appreciated.
LL

 

[feherke]

Hi

And asking here will be also unsuccessful, unless you give us more details.

Feherke.

http://rootshell.be/~feherke/

 

[Krunek]

Hello, Ladyluck!

Suppose that you have table tbl1:

create table tbl1 (
    id integer primary key,
    dsc varchar,
    dte date
);

You also have data in a csv text file (semicolon is a field separator):

1;1st row;20060415
2;2nd row;20060416
2;3rd row;20060417

Suppose that you must convert date.

Awk script can be:

BEGIN { FS = ";" }

{
    dte = substr($3, 0, 4) "-" substr($3, 5, 2) "-" substr($3, 7)
    print "insert into tbl1 values (" $1 ", " $2 ", " dte ");"
}

Output is:

insert into tbl1 values (1, 1st row, 2006-04-15);
insert into tbl1 values (2, 2nd row, 2006-04-16);
insert into tbl1 values (2, 3rd row, 2006-04-17);

Maybe this example gives you an idea.

Jesus loves you. Bye.

KP.