On 3/2/2011 9:48 AM, Ashley Sheridan wrote:
> "Jim Lucas" <li...@cmsws.com> wrote:
>> On 3/2/2011 4:25 AM, Alex wrote:
>>> You shouldn't have a default value in an auto increment field. You
>>> set AUTO_INCREMENT to 0 and start with 1, but as auto increment is a
>>> unique field and its automagically incremented, you should not set a
>>> default value on it...
>> This is fine and dandy until you want to do a restore of your data.
>> With a restore, you will probably want to retain your auto-increment
>> IDs since
>> they are probably used else where in your DB.
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
> Restoring data wouldn't need default values though, would it. You can just
> perform a regular insert statement and update the next id value to be used if
> Also, I'm not 100% sure on this one, but I thought that some versions of
> Mysql had problems with a 0 in an auto_inc field?
Sorry, I didn't mean to imply that the AUTO_INCREMENT set to 0 is fine.
Doing an export of the table structure for one of my smaller tables (that is
empty), I see that the AUTO_INCREMENT value is set to 1 by default.
CREATE TABLE IF NOT EXISTS `ajax_products` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`version` tinytext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
It doesn't show a default value, but rather a default starting point for the
OP: Show us an export of your db table structure.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php