[thelist] make mysql accept 0 (zero) as a primary key value
Brian Cummiskey
Brian at hondaswap.com
Thu Dec 9 12:53:08 CST 2004
Sarah Sweeney wrote:
> Is there some option I can add to the create table definition that will
> make this work, or a database-wide setting that will work? Any
> suggestions on how to fix this problem will be greatly appreciated.
>
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.
make a back up of your data, if any. truncate the table, which will
remove all PK's with it.
REMOVE the definition of the PK on the id row.
insert the -1 row manually
put the primary key back on the table.
load data.
that should work. if it doesn't, sorry for wasting yoru time. maybe
someone else can elaborate on the -1 usage some.
More information about the thelist
mailing list