Hi David, all!
David Stoltz wrote:
> Actually,
>
>
>
> That table isn't supposed to have a PK, so I removed that, and it
> works...same effect you suggested.
Even if you currently don't need a primary key in that table, IMO you
should still define one. Use some 'id_testresult' column with an
autoincrement clause, so you need not provide a value.
Sooner or later you may (I really think: will) feel the need to uniquely
identify a row, especially to delete it, and a primary key will be very
helpful then.
Your original problem was most likely not due to mentioning "primary
key" but rather to not providing a column name for it.
Regards,
Jörg
--
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@stripped
Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz
Amtsgericht Muenchen: HRB161028
