Note to self: To get the next auto_increment value from a table run this query: SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = $dbName AND TABLE_NAME = $tblName. Don’t forget it (again).
-
Recent Posts
Archives
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- December 2005
- November 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- November 2004
- October 2004
- August 2004
- July 2004
- June 2004
- May 2004
- April 2004
- March 2004
- February 2004
- October 2003
Categories
Meta
Bram.us is the technical/geeky weblog of Bram Van Damme (nicknamed Bramus!), a 28 year old geezer raised in Deinze and living in
MAN! THANKS FOR THIS!!!
i am searching this from years!!!!!!!
And for the record, if you want to change the auto_increment, issue the statement:
alter table tablename auto_increment = newvalue
Hahahahahahahaha!!! I really laughed hard when I read that! “Don’t forget it (again).” Hehehe.
But seriously, thanks a million, i’ve been using count() + 1 for years!! shame on me
thanks lot , i searched hundred of sites
excellent
i was doing +1 method
but this really rocks
super cool
nice!!!!
I should know this method.
let me bookmark this, and repost to my blog with backlink of course.