We insert data daily into a table in a MySQL database hosted on a Linux server.
The goal is to split a string into multiple columns max. 67 columns and insert the data into another table. The string contains an "&" sign which can be used as delimiter when extracting the data from the string.
We want to run the job on a schedule preferably with cronjobs and coded in Python/SQL.
More information available on request.
Hi, I am interested in your project related to make a python script to split data and put to columns on a daily basis. Please send me a message so that we can discuss all the details. Thanks, Ramzi
17 freelancers are bidding on average $166 for this job
Hello, We can use Python and SQLAlchemy to do the job. Using SQLAlchemy makes the code clean and easy to maintain in comparison to using SQL code in Python. Regards, Mehdi
hi i have been using mysql and python since last 5 years . so this will not be any challenge for me. may be i can show some free demo if you want to prove my skill thanks