too long

Question

How can i refer to a specific row in a table without using column or primary key? I simply want to update lets say a 3rd row in a table but I dont want to use a column with a index on that column.

Answer 1

Add LIMIT 2,1 to limit row number 3. Change the 2 to affect whatever row you want, but it's probably better to also add ORDER BY on a key.