small mysql table conversion script

small mysql table conversion script is project number 230642 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider themolla
Budget:	$30-250
Created:	02/26/2008 at 17:16 EST
Bidding Ends:	03/02/2008 at 17:16 EST
Project Creator:	zbronek   Buyer Rating: (4 reviews)
Description:	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.
Job Type:	Data Processing PHP Python
Database:	MySQL
Operating system:	Linux
Bid count:	15
Average bid:	$ 33