Em Andamento

update values in a mysql database

I have a database with 3 tables that need data updating

Flex

clf _business

Relationships.

IN all three cases, the tables have a reference to an id in another table, and i need the name of the value brought in from the other table to replace the ID value in the inital table.

eg

IN clf_business table in COUNTRY Field ID = 182634749

IN Locations table, Id 182634749, Name = Australia

in clf_business table replace 182634749 with AUstralia

fields that need matching and replacing are

clf_business table

Country

State

City

Primary_Cat1

Flex Table

Add a new field "Flex_Image"

then match Flex id in table "Images" and populate the Flex_Image Field with the image url from Images table

Relationships.

Replace All Ids, with Names from Flex table

See video here [url removed, login to view]

Immediate start, i want this job finished today don't apply if you cant achieve this

Habilidades: MySQL

Ver mais: www australia job com, replacing youtube video, new job in australia, mysql city state database, job values, country state and city database mysql, database australia, add country state, update url, mysql populate table, mysql update field, mysql update values, update database mysql, update values mysql, populate database, mysql update database, update image database, database updating, mysql update table, url update, country city database, australia database, youtube video data url, update image mysql, australia city database

Acerca do Empregador:
( 72 comentários ) Berlin, Germany

ID do Projeto: #5086877

Premiar a:

abhinay18

I went through your requirements and its easy for me to pull this. Please give me the table scripts or the access to the database.

$55 USD em 0 dias
(3 Avaliações)
3.0

3 freelancers estão ofertando em média $63 para este trabalho

elboukharimu

Aucune proposition n'a encore été fournie.

$69 USD in 3 dias
(10 Comentários)
3.8
jointsoldier

I have read description carefully. I understand your project concern. I am very much interested for this project. Ready to start immediately. I will follow all instructions. If you have any question related to deadline Mais

$75 USD em 1 dia
(4 Comentários)
3.3
Maheshml

hi i can do thsi i am expert in mysql. I can complete this with in 1 hour. Hopping for positive response. Regards, Mahesh ML

$45 USD in 3 dias
(3 Comentários)
2.0
alokhalder

We will do this within 2 days as per requirement with maintain the quality. Now we have 3 ongoing projects and completed many more. PCS Global is a renowned company in India with 3+ years experience in IT Industry Mais

$66 USD in 2 dias
(0 Comentários)
0.0