On 2/22/2012 9:47 AM, Steven Staples wrote:
Good [insert time of day here] all!
I am trying to reorder my auto-inc field in my database, and I have
successfully done it with my front end that I use (SQLYog) with the
following code:
SET @var_name = 0;
UPDATE `my_database`.`my_table` SET `id` =
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: February 22, 2012 11:07 AM
To: Steven Staples; mysql@lists.mysql.com
Subject: Re: MySQL Session Variables with PHP
On 2/22/2012 9:47 AM, Steven Staples wrote:
Good [insert time of day here] all
- Original Message -
From: Steven Staples sstap...@mnsi.net
You're asking the wrong question, though. WHY do you want to do that? You
should never, ever ever rely on auto_increment for stuff like record insert
order. Did I mention NEVER?
Autoincrements can get reset for a variety of