title: Equivalent of Oracle’s RowID in MySQL
body: <p>is there an equivalent of oracle's rowid in  mysql?</p>
  
  <p><code>delete from my_table where rowid not in (select max(rowid) from my_table group by field1,field2)</code></p>
  
  <p>I want to make a mysql equivalent of this query!!! </p>
  
  <p>What i'm trying to do is, : The my_table has no primary key.. i'm trying to delete the duplicate values and impose a primary key (composite of field1, field2)..!!</p>