Re: "call to undefined function" mysql_error when adding new rows to table
me:
Error updating database: Duplicate entry '127' for key 1
ie, for some reason, the INSERT query is trying to enter the new row
with the same primary key as an already existing row, which it
shouldn't be as it's set to auto_increment.
I've just worked out why it's doing it - the primary key is a
TINYINT...
Doh!
I'll go away and leave you all in peace now (until I have another
stupid question...)
David
.
Relevant Pages
- Re: Itanium Port Question
... It is a fine and good practice to have the primary key be the first ... if you have no reason for it to be elsewhere. ... By physicaly storing the primary key up front, rms does not have to ... I found RMS compression to ALWAYS be a net CPU AGAIN. ...
(comp.os.vms) - Re: Primary Key and Indexes, are they necessary?
... The vendor responsed that the reasons they do not add the primary key ... Indexes do slow down data entry. ... Indexes should always be evaluated and have a reason for existing. ... In Oracle 10g, the Cost Based Optimizer has been improved to the point ...
(comp.databases.oracle.misc) - Re: Primary Key and Indexes, are they necessary?
... The vendor responsed that the reasons they do not add the primary key ... Indexes do slow down data entry. ... Indexes should always be evaluated and have a reason for existing. ... In Oracle 10g, the Cost Based Optimizer has been improved to the point ...
(comp.databases.oracle.misc) - RE: Multiple subforms -- same table
... I'm not really sure why your query was non-updateable--I was ... just suggesting a common reason. ... primary key from the one side, instead of the corresponding foreign key of ... >> Jim, ...
(microsoft.public.access.forms) - Re: One to One - Multilple tables for large field qty
... If I add the third one-to-one, the primary key ... If you were advised to normalize your data, there's a reason. ... On the header table there is a form ID (primary ... joining the same FormID. ...
(microsoft.public.access.tablesdbdesign) |
|
