Em Andamento

CSV to MySQL script

I Have a MYSQL 5.0 DB with two tables that need to be updated with a bulk upload from csv file. I need an infile SQL query that we can run.

The tables are:

BRAND

field: Id :int

field: Name: varchar

field: path: varchar

field: Description: mediumtext

Example row:

1 Acura Null Null

MODEL

field: ID :int

field: Brand :int

field: Category :int

field. Name :varchar

field: Description :mediumtext

Example row:

1 1 1 NSX Null

CATEGORY

field: Id :int

field: Parent :int

field: Name :varchar

field: Path :varchar

Example row:

1 Null Cars car

The CSV file has the format (with two example rows):

Category,Brand,Model

Cars,Acura,NSX

Motorcycles,Harley Davidson,Fat Boy

The script needs to:

1. Add new models to existing brands

2. Add new brands

3. Add new models to new brands

4. Add a new "empty" model to each new brand (with Null value in Name field and same category as the other models from that brand)

We will be adding to the csv file and running the script a few times a week, which is why it needs to check for existing data.

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: php script null, category php id, car id, boy 18, mysql 5.1, acura, php upload file csv, sql query format, php mysql sql example, php mysql model, check parent, php script path, mysql data path, example mysql script, php model mysql, mysql tables rows, value engineering, models boy, sql file csv, car data file, mysql add times, cars models, nsx cars, models cars, script mysql query php

Acerca do Empregador:
( 10 comentários ) Sweden

ID do Projeto: #3024245

Premiar a:

iafelix

See private message.

$21.25 USD em 1 dia
(23 Avaliações)
3.5

16 freelancers are bidding on average $59 for this job

pShankar2

See private message.

$85 USD em 1 dia
(406 Comentários)
7.1
mmuhasan

See private message.

$25.5 USD em 1 dia
(138 Comentários)
6.6
shuvrapintu

See private message.

$46.75 USD em 1 dia
(119 Comentários)
6.4
SKJoy2001

See private message.

$67.15 USD em 1 dia
(81 Comentários)
5.9
NeoNoXtraOrdnry

See private message.

$21.25 USD em 1 dia
(85 Comentários)
5.7
aklcompany

See private message.

$76.5 USD em 1 dia
(61 Comentários)
5.7
IVasilev

See private message.

$59.5 USD em 1 dia
(51 Comentários)
5.5
vw6947279vw

See private message.

$72.25 USD em 1 dia
(20 Comentários)
5.0
softguardian

See private message.

$110.5 USD em 1 dia
(11 Comentários)
3.4
khurrampunjwani

See private message.

$42.5 USD em 1 dia
(6 Comentários)
2.8
ndrone

See private message.

$63.75 USD em 1 dia
(4 Comentários)
2.4
ashishbharti

See private message.

$8.5 USD em 1 dia
(9 Comentários)
2.1
laribaenterprise

See private message.

$102 USD em 1 dia
(4 Comentários)
2.2
sudhirsharma17

See private message.

$51 USD em 1 dia
(1 Comentário)
1.1
durga2009

See private message.

$85 USD em 1 dia
(1 Comentário)
3.4