Hi,

There is always problem that when we create keys and on deletion of those keys we get jumps in the keys. like if i am having a database of 15 values with PK values from 1-15. Now suppose i have deleted a few rows, those keys will be deleted.

Now when ever i insert new row, i'll use new value onward from 15, we dont use those delelted values. That can create our db with sparce keys ... :-s ... what should i do, how to overcome it?

thanks

You should do nothing about it.
I assume this PK is actually an artificial PK and not a real one. Especially in that case you (or your application) should never rely on any "ordering" or implicit logic in the primary key. If you do, re-think your design.

is there any way that i can make function which return a value for the next PK of a particular table ?

there is, but i cannot tell you because i think what you are trying to do is wrong

as shammat suggested, do not mess around with auto_increment numbers

let the database assign them, and then leave them alone

if you need the PK of a row, get it after insertion using the LAST_INSERT_ID function