Tell me more ×     id  name            age     2   Sandy Smith
21     4   Alie Smith      19     5   James Smith     11  Hello,
I am new to programming and am watching tutorials online this
summer in my free time. I know this is a simple question but
I've searched online and I can't find exactly what I need.  I
deleted a row so now i no longer have "id 2 3 4 5". I'm left
with 2, 4 ,5". I don't know the MySQL query to place alie smith
as #3 and james smith as #4. Please help me out with this query.
Thanks  share|improve this question IDs don't need to be
consecutive, only unique. They're not supposed to be human-
friendly but mainly machine-friendly. Trying to re-number them
for human-friendly purposes will cause more problems than it
solves. Specifically, any table which references records in the
re-numbered table would now reference the wrong records. – 
David May 24 '12 at 19:14 Oh ok. That's good to know. Thank you!
–  Shades May 25 '12 at 16:08 add comment  2 Answers  up vote 0
down vote accepted  If y