Dupe sql records

[Chris2k]

mind the scribbles in the SS, i iz not good freehand btw



how to remove dupes, iv fixed the mod tht did this

Chris2k Reviewed by Chris2k on 24th Dec 2011. Dupe sql records mind the scribbles in the SS, i iz not good freehand btw http://i.lulzimg.com/6fea8e0350.png how to remove dupes, iv fixed the mod tht did this Rating: 5

[DLow]

Hit the red delete button

[Chris2k]

fucking genious bro i no0t doing tht as theirrs lijjke 150+ records

[Lock Down]

Then you have to give us the table layout so we can give you the correct command or script.

[CJ]

FIRST OF ALL BACKUP UR DB

well am not sure, I thought about
delete table_name where id not in (select distinct id from table_name)

but then i thought it wont distinct out "sitename" field
let me think someway out...if I couldnt do it via query we would design a php code to do it which would make it easy tbh

[Chris2k]

done it, luckily i backed upv da table 18 hours ago

[Lock Down]

FIRST OF ALL BACKUP UR DB

well am not sure, I thought about
delete table_name where id not in (select distinct id from table_name)

but then i thought it wont distinct out "sitename" field
let me think someway out...if I couldnt do it via query we would design a php code to do it which would make it easy tbh

You can't delete from a table in a select from the same table. Mysql won't allow it.

You should never offer a novice mysql commands without knowing the exact table and field names involved in the command.......

Especially ones that you are not sure and have not tested on your test table!!!!!!!!!!!

[soft2050]

1. Backup the database (in case any problem occurs, though we would be already backing up the database in this way too)

2. Rename the table to old_backup (Dont forget to keep your site offline for the timebeing)

2. Open PHPMYADMIN --> Select the table and execute this query:

CREATE TABLE `original_table_name_here` as SELECT * FROM `renamed_name` WHERE 1 GROUP BY `url` 

Replace original_table_name_here with the old table name you had and renamed_name to the name you just renamed above

I have tested doing same with DLE script to remove fucking duplicate posts. And it did worked successfully.