Find Jobs
Hire Freelancers

Create MySQL statements from CSV file

$30-250 USD

Cancelled
Posted over 14 years ago

$30-250 USD

Paid on delivery
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 [login to view URL] [login to view URL] “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.
Project ID: 512063

About the project

40 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $54 USD for this job
User Avatar
I can do this in Delphi and C++ Just a Small Project Been a Programmer for past 5 years.
$30 USD in 0 day
4.9 (23 reviews)
5.8
5.8
User Avatar
Dear sir, I can do it for you, Could you see PMB for more details? Thanks. Best Regards.
$30 USD in 1 day
5.0 (56 reviews)
5.6
5.6
User Avatar
Please check PM. Thanks.
$40 USD in 1 day
4.9 (20 reviews)
5.5
5.5
User Avatar
Hi, Indian guy here from mumbai. Please check PM to check my ability for this work. Thanks, Sumeet.
$100 USD in 2 days
5.0 (7 reviews)
5.2
5.2
User Avatar
Hi, Please, see PM
$30 USD in 1 day
5.0 (33 reviews)
5.2
5.2
User Avatar
can be done
$30 USD in 1 day
5.0 (67 reviews)
4.9
4.9
User Avatar
Hi Good day, Ready to start the work.
$30 USD in 1 day
4.9 (17 reviews)
4.7
4.7
User Avatar
I have developing dynamic SQL for Ms-SQL, MySQL and other databases. i will provide quick & prfoessional service.
$50 USD in 1 day
4.9 (18 reviews)
4.7
4.7
User Avatar
we have extensive Perl programming and MySQL experience. See PMB for addt'l details. Mickalo
$50 USD in 1 day
5.0 (3 reviews)
3.9
3.9
User Avatar
I should be able to deliver the project on time. Please check your personal message.
$100 USD in 2 days
5.0 (8 reviews)
3.6
3.6
User Avatar
Hi, I am interested in your project.
$30 USD in 1 day
5.0 (11 reviews)
3.7
3.7
User Avatar
please view pm
$50 USD in 1 day
5.0 (10 reviews)
3.8
3.8
User Avatar
did the similar before. hope to work with you.
$30 USD in 1 day
5.0 (2 reviews)
3.8
3.8
User Avatar
Please view PM for details.
$40 USD in 2 days
5.0 (8 reviews)
3.8
3.8
User Avatar
Check pmb for details
$50 USD in 1 day
5.0 (7 reviews)
3.2
3.2
User Avatar
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 databases. I will produce MySQL statements according to given instructions, from CSV file. I will provide quality work and work with you till your 110% satisfaction.
$75 USD in 1 day
4.2 (12 reviews)
4.0
4.0
User Avatar
Just a one day job
$30 USD in 1 day
5.0 (13 reviews)
3.0
3.0
User Avatar
Dear Sir, I can build this application. I will built it using delphi. Winata
$30 USD in 3 days
5.0 (2 reviews)
2.5
2.5
User Avatar
Let's start. I am a software professional and have completed many similar projects.
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please see your pmb. Regards.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Warren, United States
5.0
1
Member since May 31, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.