Delete duplicate rows from mysql

  SET SQL_SAFE_UPDATES = 0;

    DELETE t1  FROM sh_learning_material AS t1

INNER JOIN sh_learning_material AS t2 

WHERE 

t1.id<t2.id AND

    t1.company_id = t2.company_id;