Bash Script CSV > mySQL


I need a bash script with the following functionality:

1) Download a CSV File from given URL (size up to 200.000 lines)

2) Import selected columns into a mysql database (emtpy the table before import)

The CSV file format:


if it's better (performance! up to 200.000 lines) with PHP please use PHP.

Thank you!

Beceriler: Linux, MySQL, PHP, Yazılım Mimarisi

Daha fazlasını gör: bash csv mysql, import csv into mysql php script, bash file, bash 0, linux bash script, bash script, php table csv, linux import mysql script, php mysql import script, table csv, php import csv file mysql, csv table, import csv mysql php, script import mysql file, csv bash, bash script csv, import csv database, import mysql csv, csv mysql import, linux performance, mysql import database csv, script thank url, php csv import mysql script, csv import database, php script download linux

İşveren Hakkında:
( 28 değerlendirme ) Berlin, Germany

Proje NO: #4446430



Lets do it right away.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(21 Değerlendirme)

Bu iş için 4 freelancer ortalamada $57 teklif veriyor


I specialize in similar projects. Please check PM for more details.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(18 Değerlendirme)

I cna do the required job, when can we start

in %bids___i_period_sub_35% gün içinde71%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

I would prefer to implement it in Perl, but any language (shell + wget + mysql command-line client, or PHP, or whatever) will basically [url removed, login to view] take less than a day. Would like to have the exact description of mysql Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)