Find Jobs
Hire Freelancers

PHP Script Needed For Modifying MySQL Table

$30-250 USD

Completed
Posted about 9 years ago

$30-250 USD

Paid on delivery
Need a php script that will remove all duplicates while retaining the auto increment counter. The following is a sample table. +----+-------------+-------------+----------------+----------------+----------------+ | id | bf_use_id | bf_status | FIELD_342 | FIELD_996 | FIELD_997 | +----+-------------+-------------+----------------+----------------+----------------+ | 1 | 13 | Paused | TRUE | Text | NULL | | 2 | 80 | Paused | FALSE | | NULL | | 3 | 10 | Paused | FALSE | | NULL | | 4 | 10 | Paused | FALSE | | NULL | | 5 | 10 | Paused | FALSE | | NULL | +----+-------------+-------------+----------------+----------------+----------------+ We need to remove id 4 and 5, leaving 3. The next entry resuming at id 4.
Project ID: 7672938

About the project

29 proposals
Remote project
Active 9 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
hi there, As we have discussion over Skype i have edited my my bid . Thanks & regards satish kumar
$66 USD in 1 day
5.0 (7 reviews)
2.8
2.8
29 freelancers are bidding on average $88 USD for this job
User Avatar
Hi I am confident to do this job. ========================================================================= thanks
$100 USD in 1 day
4.9 (587 reviews)
8.3
8.3
User Avatar
Hello! With 98% to 99% completion rate, 800+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$147 USD in 1 day
5.0 (606 reviews)
7.7
7.7
User Avatar
I am an expert in PHP and look forward to discuss further about the project and deliver the same asap
$84 USD in 3 days
4.8 (119 reviews)
7.2
7.2
User Avatar
Hello, Are we talking about a single table? Would it be possible to get a bigger dataset as a sample from you? Kind regards pixelke
$105 USD in 1 day
5.0 (84 reviews)
6.4
6.4
User Avatar
A proposal has not yet been provided
$49 USD in 3 days
4.9 (207 reviews)
6.6
6.6
User Avatar
Hi, We are experts in mysql/php. We can write this for you. One question. Does this records come only at the end of the table? Ready to start now. Thanks. Changed the bid to $40.
$40 USD in 1 day
4.9 (201 reviews)
6.5
6.5
User Avatar
Hi, You need a MySQL query, which you can easily run from any tool, even phpMyAdmin if your host provider has that in cPanel. If you insist on a PHP script, then that script will just contain some mundane code with database credentials, and run the de-duplication query. Questions: 1. Is that the specific table required? 2. Are those the exact field names to de-duplicate against? 3. Is this a one-off - you give me credentials, I run it once - or is this script something you want to run over and over again in future? Regards, Richard
$45 USD in 1 day
5.0 (61 reviews)
6.1
6.1
User Avatar
Dear You, i can do it and finish 1 days. I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks! Mr Khoa
$60 USD in 1 day
4.9 (80 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$256 USD in 0 day
4.4 (90 reviews)
6.0
6.0
User Avatar
Hi, I can write in a single day. Thank you, Goran
$122 USD in 1 day
5.0 (18 reviews)
4.6
4.6
User Avatar
hello. can be done. it need access to your phpmyadmin (cpanel). first of all we'll create back-up of database. than we'll make php-script to perform table as you want. additionally, we can try to implement script to your site to prevent dupplication. we provide free 30 days support after project finished. thanks, Yuriy
$55 USD in 2 days
5.0 (9 reviews)
3.7
3.7
User Avatar
I have a PhD degree in computer science and excellent skills in PHP and MySQL. Please click ALL SKILLS to see my complete rating score. I KNOW how to do what you need. I've done many similar projects, please see the reviews on my profile. It would be my pleasure to do project.
$40 USD in 1 day
5.0 (7 reviews)
3.7
3.7
User Avatar
Please let me do it. I will complete soon to help you. Important thing I will support you in the future. and your data errors will not occur again in the future. Thank for reading Joomla2Project
$60 USD in 1 day
5.0 (4 reviews)
1.7
1.7
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
5.0 (1 review)
0.9
0.9
User Avatar
i am php expert and have done many project of this type. I can assure 100% satisfaction for quality work. Please feel free to ask any questions. Looking forward to fruitful response. Kind Regards, Abdul Ghffar
$155 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
My idea is to remove the duplicates, then re-generate the id field. Or if you want to keep the ids and only continue from the lates remaining, that's ok, too. (If you are using the IDs you will need this solution) If the data is not overly complex, I think this can be done from SQL without PHP, too. You could also prevent duplicates by setting up a unique constraint (if your input source can handle that, maybe it needs to be modified to ignore errors if there is a duplicate entry error) Maybe you could give another example where the removed entries are not the last ones to clear this question.
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i will do it with custom php and MySQL. i will complete your work in few hours will need your SQL table if you have if no then i will create table with fields provided by you
$70 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 10 years experience in software development.i can do the job with 100% accuracy and future support
$222 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I just finished my php projects for my university. I have an hands on experience. Do let me know. :)
$90 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
In one day i can do a documented configurable php class with the methods to remove duplicate from mysql database and a web page with graphic ui to use the class. Programming PHP is my job since five years
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Fort Lauderdale, United States
5.0
7
Payment method verified
Member since Aug 25, 2012

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.