Home › Questions › PHP & MYSQL?
using php & mysql i want to reorder the auto incremnt from a certain row to begin from 150001 instead of 1501, knowing its has already reached 16102 now
I could figure it out this way for anybody face these kind of issue here is the solution :
SET @num := 150000;
UPDATE tel_pf_tasks SET id = @num := (@num+1) where id > '15000'
You must sign in to view your friends.