NYCPHP Meetup

[Daniel Convissor]

Peter:

On Sat, Jul 24, 2010 at 12:55:21PM -0400, Peter Sawczynec wrote:

> understand one way to get around this all is to remove the record with the 
> autoincrement value of 0. After that this mode would no longer be needed.
> IIRC 
> you cannot simply edit an autoincrement field (by design), so you'd need to 
> take the restrictions of and do some data massaging.

Sure you can.  This query should run without incident.

UPDATE table SET id = MAX(id) + 1 WHERE id = 0;

--Dan

PS:  Get an email client that knows how to properly quote prior messages 
you are replying to.

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409