Re: Help needed with mysql import
| From: | Jim Lucas | Date: | Wed, 02 Mar 2011 16:59:56 +0000 |
| Subject: | Re: Help needed with mysql import | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-311617@lists.php.net to get a copy of this message | ||
On 3/2/2011 4:25 AM, Alex wrote:
> You shouldn't have a default value in an auto increment field. You can
> 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.
Jim