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.
Bu iş için 4 freelancer ortalamada $57 teklif veriyor
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