Find Jobs
Hire Freelancers

Need Help With MySQL Queries in Batches, Chunks, etc for Millions of Rows/Records

$15-25 USD / hour

Completed
Posted about 2 years ago

$15-25 USD / hour

I need to format, insert, delete and update tons of rows in some big tables (that have millions of rows/records). And, I can't seem to get any of these queries (from the links below) to work, but I'd like someone that knows how to do queries like this. So far, I've just been running my queries in the SQL tab in PHPMyAdmin with limits of 10,000 or 100,000 or 500,000 or 1,000,000 and waiting for it to finish. And, that's been succssful, but I keep having to go back in and see if the query is done and pasting it again to run it again. So, I need it to be more continuous. A CRON Job might be good, but I often need to run different update queries, so I really want to just know how to do this with the batch method. I've read that using the PK (primary key) to batch the records to update in an update query is the fastest way. I can also run queries from Terminal (ie. Command Line) in my WHM if someone can teach me how to write the batch query (if that's even a fast way of doing it). If someone can teach me how to do this stuff myself, then I will probably hire you to help me a few hours or more per day to help me format some of the data in my tables in preparation for a big project. Here are some of the queries I think might help me if I knew how to run them correctly: [login to view URL] [login to view URL] [login to view URL]
Project ID: 32563019

About the project

17 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello there. PHP&Cronjob Expert HERE. Please feel free to contact me so we can start right now. Regards. Stevan.
$20 USD in 40 days
5.0 (11 reviews)
4.8
4.8
17 freelancers are bidding on average $24 USD/hour for this job
User Avatar
Hey Manager!! We checked for your project and interested in your project. Project: Need Help With MySQL Queries in Batches, Chunks, etc for Millions of Rows/Records I am professional full stack engineer with skills including Database Programming, PHP, MySQL, Database Administration and SQL.
 I have done several complex projects and provide continuous maintenance support. My goal has always been to provide reliable and efficient to my clients and so far I have been quite successful. I won't delay your project and will keep you updated with constant feedback and status of the work My Full Stack Development Skills 1. Frontend: Front-End HTML5, CSS/CSS 3, JavaScript, 2. Server Administration: Amazon Web Services, Digital Ocean, LAMP, Cloud, Apache, Apache Tomcat, NGINX. 3. Backend: PHP, GoLang, Ruby, Python, Laravel, CI, CakePHP. 4. Databases: Mysql, Oracle, PostgreSQL, MS SQL, SQLite, MongoDB. 5. Testing: Manual & Automation testing. 6. Frameworks: Angular Js, React JS, Symfony2, Laravel, Silex, Spring MVC, Rails, Django, Pyramid, Protractor, Selenium, Blockchain, Etherume, Vuejs 7. UI/UX: Photoshop, Sketch, Zeplin, Invision, Moqups. Type of projects we have delivered to our global clients: a. Enterprise Software Development, b. CRM Development, c. SAAS Product Development c. Web/Mobile Based Application development. d. All CMS website: Wordpress, Magento, Joomla, e. HRMS Software f. Multi-level Marketing (MLM) with crypto payment gateway f. E-commerce installation and customization g. Crypto Exchange Development Please chat to discuss more regarding this project.
$21 USD in 37 days
4.8 (48 reviews)
6.7
6.7
User Avatar
Hello there I don't work with MySQL - but I work with SQL Server and I have written SQL query for fast order update using batching I can provide you the same script to you if you want and you can write same/similar script for your requirement Please connect over chat to start the conversation Thank you
$30 USD in 40 days
5.0 (20 reviews)
4.7
4.7
User Avatar
Yo!, I’ve carefully checked your requirements and really interested in this Need Help With MySQL Queries in Batches, Chunks, etc for Millions of Rows/Records I went through your project description. I am a Professional Web Developer and have done many complicated projects and can complete your project within days. I will be very delighted to assist you and give my all to this work and charge you less. For further details, you may contact me privately. Thank you. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thanks
$50 USD in 29 days
5.0 (7 reviews)
3.1
3.1
User Avatar
Hi I am a senior MERN and MEVN full stack develper. Also, i am very skillful in Laravel and CI framework, further, have experience with laravel-vue or laravel-react combination projects. Also, very skillful in database management. I have just read your specification with deep concern and interest. I understand full requirment and get to know What to do. As a result, I am sure that I can deliver a good product to you within timeline. Please initialize our chat now. Best regards
$20 USD in 40 days
5.0 (3 reviews)
2.3
2.3
User Avatar
Hello I have gone through your requirements in detail. I am a web expert having great experience in Database Programming, SQL, PHP, MySQL and Database Administration. I will provide you the website as per your requirements where you can easily manage the website content and functionality easily. The website will be clear responsiveness for all devices and SEO friendly There can be negotiations about the price according to your requirements. And I am confident to provide an innovative result with my skills and dedication. Please feel free to contact me so that we can discuss the further project and your needs in detail.
$30 USD in 39 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there. I'm full stack developer. As you can see in my portfolio, I'm a algorithm expert. I have a strong grip on algorithms, data structure and coding as I not only took part but won many programming contests. So I can create sql simply and quickly. I am sure you will not be disappointed if you give me this opportunity. I am experienced, creative & efficient enough to get your job done well. Please contact me. Thanks
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Let me try, I have 6 years of experience in SQL. May be I can help you out this. I have written dynamic queries in my work and may be we can try using stored procedure for repeating the same process
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Chicago, United States
5.0
8
Payment method verified
Member since Dec 9, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.