title: How to update a specific row in a table without a primary key in MySQL?
body: <p>I am trying to use an UPDATE query in MySQL database table. I have primary key that auto increments in the table but I don't want to use this key when doing this query. This is because this column doesn't restart its count when records are deleted so there are gaps in the table. For example, if I delete row 25 and then INSERT a new row, the ID of that row/will be 26. So back to my question, I want to know how I can edit the values of one specific record/row. I have tried the following:</p>
  
  <pre><code>UPDATE `table_name` SET `first_Name` = "Robert" WHERE (SELECT * FROM `employees` LIMIT 1,1)
  </code></pre>
  
  <p>This was my try of updating the firs_Name in the second row only. But it doesn't work. There is some syntax error. Is there any other way to do this? Or can I solve the problem of the auto-incrementing column (I would prefer an answer that ignores this).</p>
  
  <p>Thanks in advance!</p>