176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

[mysql] Create database structure and add particular lines from txt file
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Oct 19, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Oct 19, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Hourly Rate: $40 - $50 / hr
  • Hrs/wk: Not Sure | Duration: 2 hrs
  • Work View™ Payment Protection
  • W9 Not Required
Sign in to view client's details

I'm struggling to add data from a text file into a mysql database. In my text file I have dozens of lines from which I want to extract just specific ones (which are the ones with a similar structure as the table structure).

Table structure:
Name
Surname
Email
City
ZIP

Text File:
_field1 >>> blah
otherfield >>> blah
Name >>> John
anotherfield >>> blah
Email >>>   [obscured]  
City >>> Portland
ZIP >>> 90210
yetanotherfield >>> foo

So we want to import just particular lines into database.

Sign in or Register to see more

Job ID: 34499339
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Ashutosh S.      
Ashutosh S.'s identity has been verified.  Learn More
 India  |  
Devoted IT professional having more than 9 years of experience in Database, Web and Automation technologies. Database Technologies : - Sybase...
8
  |  
 5.0   |  Private   |  21 Jobs
Bid ID: 34500747  |  Submitted: Oct 19, 2012 11:37 ET 
Proposal SEALED

 United Kingdom  |  
Degree in electronic engineering and computer science, currently working as Python developer in London. I have 3 years experience in Python and...
Skills: C++, Python, C, LISP
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34500739  |  Submitted: Oct 19, 2012 11:36 ET 
Proposal SEALED

 India
Hello, I have experience in HTML, CSS, JQUERY,Javascript , core PHP. I have good command over CMS like Wordpress, Magento, osCommerce, Open Cart,...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34500694  |  Submitted: Oct 19, 2012 11:34 ET 
Proposal SEALED

 India  |  
Over 5 years magento/wordpress/opencart/prestashop and Adwords experience. Clear and prompt communication and availability on skype and phone. I...
11
  |  
 5.0   |  Private   |  37 Jobs
Bid ID: 34500249  |  Submitted: Oct 19, 2012 11:16 ET 
Proposal SEALED

 Argentina  |  
Winner
Computer engineer with more than 10 years of work experience. * Highly skilled with SQL, and I have worked using Microsoft SQL Server and MySQL...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34500214  |  Submitted: Oct 19, 2012 11:15 ET 
$28.00/hr
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »