如何从MySql数据库表中删除重复的条目

Question

I had heavy SQL dump of a table. I used bigdump lib to import it in MySql database on my server. Although it worked fine, but now I have duplicated entries in that table. same table on local server has 8 * 10⁵ records but on server it has 15 * 10⁵ records.

Can you suggest me a query to delete duplicate entries from this table? Here is my table structure.

Table name is : techdata_products

P.S. This table does not have any primary key.

Answer 1

SQL is not my strong point but I think you can export the result of this query:

SELECT DISTINCT * FROM table;

And then, create a new table and import your results.