How to delete duplicate rows in my sql database?

Question

How can i delete duplicate rows in my database name ( VB) included 255 tables using ALTER TABLE in PHP my admin ?

check here stackoverflow.com/a/1652413/4421474

Alex
– Alex

2015-03-26 13:07:57 +00:00
Commented Mar 26, 2015 at 13:07 — Alex
– Alex, Commented Mar 26, 2015 at 13:07

Rahul Tripathi · Accepted Answer · 2015-03-26 12:22:48Z

0

You can try to add unique index like this:

ALTER IGNORE TABLE tablename ADD UNIQUE INDEX idx_name (columnname1,columnname2 );

This query will drop all the duplicate rows from your table and it will also restrict users to add duplicate rows in future in the table.

answered Mar 26, 2015 at 12:22

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mohammad Ahmad Al Ajouri Over a year ago

Error SQL query: ALTER IGNORE TABLE vb ADD UNIQUE INDEX idx_name (columnname1,columnname2 ) MySQL said: Documentation #1146 - La table 'vb.vb' n'existe pas

Rahul Tripathi Over a year ago

@MohammadAhmadAlAjouri:- 1. Please translate the error in English. 2. You need to mention the column name present in your table not columnname1 and columnname2. These are examples

Mohammad Ahmad Al Ajouri Over a year ago

*****@p3plcpnl0192 [~]$ mysqldump -u vbok -p --hex-blob --opt --default-character-set=latin1 vbok > new.sql Enter password: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table post at row: 63755 wwwowtjo@p3plcpnl0192 [~]$

Collectives™ on Stack Overflow

How to delete duplicate rows in my sql database?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related