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.
15 freelancers are bidding on average $33 for this job