In Progress

small mysql table conversion script

I have mysql table 'clients' with lot of columns, ie. MobileNumber, Email, MaritalStatus (it's description of customer).

I have second table: clients_data(id int,id_client int,fieldname varchar,value varchar).

I want script which will read data in 'clients' and save it into 'clients_data', for example:

If row with id=123 will have column MobileNumber='+1 123123123' in 'clients',

then it will be saved as such row in 'clients_data':

INSERT INTO clients_data(id_client,fieldname,value) VALUES(123,'mobile_phone','+1 123123123')

I will provide structure of database and list of fieldnames in clients_data to selected coder.

Database: MySQL 4.

Script: can be just .sql file, but it can be also php or python script.

Skills: Data Processing, PHP, Python

See more: table data structure, table customer, sql data conversion, mysql customer database, int i, data conversion sql, customer table, mysql table conversion, small mysql, table, sql script , sql mysql, python script, mysql 4, int, file conversion, python read, php data table, small data table, mysql structure, read structure file, php mysql sql example, sql python php, mysql save data, example mysql script

About the Employer:
( 46 reviews ) Kostrzyn Wlkp, Poland

Project ID: #230642

Awarded to:

themolla

Ready to work! :) I'm a student (comp. engineering) and I need this job :)

$34 USD in 1 day
(3 Reviews)
2.0

15 freelancers are bidding on average $33 for this job

NickolaS

Hi, please, check your PM

$30 USD in 0 days
(334 Reviews)
7.5
BestWeb4U

Dear Sir/Madam I am very happy if I can work for you I can do this project,expertized, professional with an experience of 7 years in making website designs, graphic designs, logo designs, flash and template designs I More

$40 USD in 1 day
(167 Reviews)
7.5
a1dezine

Hi, please, check your PM

$30 USD in 0 days
(68 Reviews)
7.0
eelance

easy works. i can do that for you.

$30 USD in 0 days
(354 Reviews)
6.8
MAnkita

Hello,Please refer your PMB.Thank you.

$30 USD in 1 day
(107 Reviews)
6.8
justinsylas

sir, i can

$30 USD in 1 day
(32 Reviews)
6.6
Pektsekye

why you cannot write it yourself? looks like simple and i see you are a programmer also

$30 USD in 1 day
(107 Reviews)
5.6
bdsources

Aaah! Damn easy, let me do it.

$30 USD in 0 days
(14 Reviews)
5.6
SteeleR

can do it right away.. Regards, SteeleR

$30 USD in 0 days
(14 Reviews)
5.4
RajakScripts

Hi, I can help you to convert it, please read PM.

$60 USD in 1 day
(13 Reviews)
4.5
southpeak

I've done something like this before

$30 USD in 1 day
(0 Reviews)
0.0
milohoffman

Hi! I had deals with databases before, I;m ready to help you

$30 USD in 1 day
(0 Reviews)
0.0
kenson2127

Hi, New joiner to the site. Will do my best to build my portfolio. 4 years working experience in MNC company, expertise in C#, ASP.NET, SQL, Javascript, XML

$30 USD in 0 days
(0 Reviews)
0.0
arrinfo

please read PM

$30 USD in 0 days
(0 Reviews)
0.0