[thelist] make mysql accept 0 (zero) as a primary key value
David Siedband
technique at oceanicsky.com
Fri Dec 10 14:15:44 CST 2004
This is a documented issue. MySQL InnoDB tables don't like 0 as a
primary key.
You can manually enter it but if you alter the table it re-increments.
If you google with the title of your original e-mail this is the first
response
http://bugs.mysql.com/bug.php?id=3431
--
David Siedband
generation-xml.com
On Dec 10, 2004, at 5:49 AM, Sarah Sweeney wrote:
>> ususally when a default option is needed, i try to use -1 as the
>> value. it tends to go over smoother and avoid the problems you are
>> hitting right now.
>
> This would work, except that I have the 0 hard-coded in various places
> and it appears as a foreign key in several other tables. (But thanks,
> Brian!)
>
> More info, in case it helps: if I open the dump file and move the
> insert statement that adds the row for AgencyID = 0 after the insert
> statement that adds the row for AgencyID = 1, it works fine.
>
> Unfortunately, the database is huge, so making this simple change to
> the dump file every time I copy the database is a major pain - it's
> hard to find an editor that will happily open a 264MB text file :) For
> now, I've settled with running the dump on all tables but the
> troublesome one, but it would be a lot easier if I didn't have to do
> that.
>
> --
> Sarah Sweeney :: Web Developer & Programmer
> Portfolio :: http://sarah.designshift.com
> Blog :: http://hardedge.ca
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester and
> archives of thelist go to: http://lists.evolt.org Workers of the Web,
> evolt !
More information about the thelist
mailing list