Peruttu

Create MySQL statements from CSV file

Need a program to create MySQL statements based on CSV file as follows:

How to Run:

Input: <<Input CSV File Name>>, <<Output MySql Statements File Name>>, <<Input Id Field Name>>, <<Input Create Date Field Name>>, <<Input Modify Date Field Name>>, <<Table Name>>, <<Output Id Field Name>>, <<Output Create Date Field Name>>, <<Output Modify Date Field Name>>

E.g. YourProgram [url removed, login to view] [url removed, login to view] “Id” “CreatedDate” “LastModifiedDate” “accounts” “date_entered” “date_modified”

Your Program is supposed to the following:

Skip the header from .csv file and user the header to locate the input Id, Create Date and Modify Date fields.

Go thru each row

Create update statement based on arguments passed (e.g. update accounts set date_entered = XXXXX, date_modified = YYYY where id = ZZZZZ;)

You may have to use some format function to make the date format suitable for mysql.

Output to outfile.

End of loop

Flush the buffer s to make sure output file is not truncated.

Taidot: C-ohjelmointi, C# -ohjelmointi, Excel, Perl, SQL

Näytä lisää: csv mysql, mysql csv file, update mysql, statements, skip , mysql 4, make loop, CSV, csv file, create e, update sql file, mysql function update, csv update, mysql sql function, mysql update field, mysql loop sql, mysql create table fields, mysql update function, mysql date field, table perl, table csv, perl table, mysql output table, loop table, mysql create table

About the Employer:
( 1 review ) Warren, United States

Projektin tunnus: #512063

43 freelanceria on tarjonnut keskimäärin 54 $ tähän työhön

Mindon

Check the PM pls

80 $ USD 1 päivässä
(61 arvostelua)
6.2
fstudio

Dear sir, I can do it for you, Could you see PMB for more details? Thanks. Best Regards.

30 $ USD 1 päivässä
(56 arvostelua)
5.6
alexander2007

Please check PM. Thanks.

40 $ USD 1 päivässä
(20 arvostelua)
5.5
amelnyk

Hi, Please, see PM

30 $ USD 1 päivässä
(24 arvostelua)
4.9
egg

can be done

30 $ USD 1 päivässä
(53 arvostelua)
4.7
crajeshbe

Hi Good day, Ready to start the work.

30 $ USD 1 päivässä
(17 arvostelua)
4.7
nmppatel

I have developing dynamic SQL for Ms-SQL, MySQL and other databases. i will provide quick & prfoessional service.

50 $ USD 1 päivässä
(18 arvostelua)
4.7
DamithaKD

I can do this in Delphi and C++ Just a Small Project Been a Programmer for past 5 years.

30 $ USD 0 päivässä
(8 arvostelua)
4.3
mickalo

we have extensive Perl programming and MySQL experience. See PMB for addt'l details. Mickalo

50 $ USD 1 päivässä
(3 arvostelua)
3.9
nadeem2005

I am experienced C# developer. I have already used CSV file ( to get data and producing data) in a number of projects. I am well familiar with CSV file format and I also know what formats of date are used in MySQL data Lisää

75 $ USD 1 päivässä
(12 arvostelua)
4.0
pbq

did the similar before. hope to work with you.

30 $ USD 1 päivässä
(1 arvostelu)
3.8
kopila123

please view pm

50 $ USD 1 päivässä
(10 arvostelua)
3.8
is00hcw

Hi, I am interested in your project.

30 $ USD 1 päivässä
(11 arvostelua)
3.7
alanhaggai

I should be able to deliver the project on time. Please check your personal message.

100 $ USD 2 päivässä
(8 arvostelua)
3.6
rptoshniwal

Please view PM for details.

40 $ USD 2 päivässä
(6 arvostelua)
3.5
akhd

Check pmb for details

50 $ USD 1 päivässä
(7 arvostelua)
3.2
coderforrental

Just a one day job

30 $ USD 1 päivässä
(13 arvostelua)
3.0
vdmitr

Can be done within 2-3 hours.

30 $ USD 0 päivässä
(1 arvostelu)
2.6
win4t4

Dear Sir, I can build this application. I will built it using delphi. Winata

30 $ USD 3 päivässä
(2 arvostelua)
2.5
bhonti

Did phonebook, and other mysql import/data conversion with perl scripts from excel/csv a lot of times before. Time told is safe maximum.

60 $ USD 2 päivässä
(1 arvostelu)
1.4