mysql get free id
#3

Quote:
Originally Posted by MdeRooy
View Post
Do you mean fill up a deleted row?
no, something like this

in my table (id 5 missing);

SomeID = 1 | Name = TestNAME
SomeID = 2 | Name = TestNAME
SomeID = 3 | Name = TestNAME
SomeID = 4 | Name = TestNAME
SomeID = 6 | Name = TestNAME
SomeID = 7 | Name = TestNAME
SomeID = 8 | Name = TestNAME
SomeID = 9 | Name = TestNAME

but when i run this code
mysql_query("INSERT INTO `rofl`(`SomeID`, `Name`) VALUES (LAST_INSERT_ID() + 1, 'TestNAME')");
it is supposed to fill the free row (id 5) but it dont
Reply


Messages In This Thread
mysql get free id - by Unknown123 - 07.12.2011, 19:54
Re: mysql get free id - by MdeRooy - 07.12.2011, 19:56
Re: mysql get free id - by Unknown123 - 07.12.2011, 20:00
Re: mysql get free id - by MdeRooy - 07.12.2011, 20:03
Re: mysql get free id - by Unknown123 - 07.12.2011, 20:09
Re: mysql get free id - by MdeRooy - 07.12.2011, 20:20
Re: mysql get free id - by [HiC]TheKiller - 07.12.2011, 20:22
Re: mysql get free id - by MdeRooy - 07.12.2011, 20:24

Forum Jump:


Users browsing this thread: 1 Guest(s)