Færdiggjort

query mysql, look for a string, update a field, if not found, look for another string et

select some rows from mysql

if any row contains the word total: extract the value after total and before DA

if the row does not contain the word total, check if it contains the word MAXY

if it contains the word MAXY extract value between MAXY and DA

if it does not contain either of those

check if it has the word

Crédit :xxx DA where xxx is a variable

if contain, then extract

extracted value updates another table

this will be called by cron

Evner: MySQL, Bash Scripting, Shell Script, Scripting, Python

Se mere: create update query mysql, mysql update query, update query mysql aspnet, asp script mysql update query, mysql update random select, update field mysql php, php mysql update form select option selected, php select drop list query mysql, update mysql javascript field, php query mysql html drop select, mysql update select 323, php mysql update field popup, php mysql update field option drop, mysql update select query, mysql update field

Om arbejdsgiveren:
( 108 bedømmelser ) dix hills, United States

Projekt ID: #20357276

Tildelt til:

karimnikitin

Hello, I already created a script what you need except updating tables with extracted values. I would like to get the details such as table name, field name and other specs then I will update my script. Regards

$15 USD in 7 dage
(0 bedømmelser)
0.0

13 freelancere byder i gennemsnit $29 på dette job

kipdev13

Nice to meet you. Very interested in your project. I have good talents and skills of SQL. We can share more details of work via chat. I will try to my best for work. Fast speed, Best quality, Delivering on time is my b Flere

$30 USD på 1 dag
(92 bedømmelser)
6.8
elbruninh

Hi, i'm interested can you send me the database structure? (with sample data) i can do it with PHP 2-3 hours regards [login to view URL]

$35 USD på 1 dag
(51 bedømmelser)
5.9
osmanaydin

Hello sir, Please take a look at my reviews and portfolio. I have completed web/data scraping jobs for many times. I am interested in your project as well. I would like to discuss details via pm. I look forward to he Flere

$100 USD på 1 dag
(29 bedømmelser)
5.2
pks11

Hello Sir/Madam, Greetings of the day..! Hope you are doing well. I have gone through your requirement details and understood it completely. I have good command on mysql database and queries. I assure you to provide b Flere

$20 USD på 1 dag
(23 bedømmelser)
4.7
drohanyadav

Hi, if you can provide me the sql file then I can use pandas module in python and update the database as you have asked. This will be done in an hour or two. Please contact me if you are interested

$20 USD på 1 dag
(7 bedømmelser)
3.6
chcoder719

I have carefully read your project description and your job hits off my challenge sense. I am a Senior Web Developer with extensive knowledge and lots of experiences in front-end/back-end web developments over the pas Flere

$20 USD in 7 dage
(4 bedømmelser)
2.6
adricabrelles

Hi, I'm a Senior DBA and programmer PL/SQL with more than 15 years experience in mysql. I can help you. Regards.

$30 USD på 1 dag
(2 bedømmelser)
1.9
Varinderchhabra

Hi, I hope you are doing well. I am very interested in the project and you would like to apply to it. I'm a web developer with 7 years experience in PHP, laravel, CodeIgniter, deep knowledge Wordpress, WP pluggin, Flere

$10 USD på 1 dag
(1 bedømmelse)
0.7
bestw7707

Hello, sir! ************* I can do it for you in a short time perfectly. ********* Please contact with me, let's share details. If our contract make, i can start work from now. I am ready for you anytime. Hoping for yo Flere

$20 USD in 7 dage
(1 bedømmelse)
0.0
Saimi786

Hello Thanks for your posting. Your requirements are fully clear to me and I am applying only because I meet all the requirements that you are looking for. I have been working as a web developer and designer for more t Flere

$15 USD in 7 dage
(0 bedømmelser)
0.0
inforafeesoft

Hi sir I'm a [login to view URL] Engineer Database Administrator and System Administrator Also Network Administrator I'm expert in Database (My SQL,MS SQL,Azure,AWS,Mongo Db,Postgre DB,Magento ...etc), Java, Java Script, PHP, Flere

$30 USD på 1 dag
(0 bedømmelser)
0.0
motazalnuweiri

Hi, I can help you with what you need, I'm an expert developer and I have worked a lot with MySQL and SQL query. Feel free to contact me to discuss more details about the project, Thank you

$30 USD in 7 dage
(0 bedømmelser)
0.0