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.bru...@sun.com
Sun Microsystems GmbH,   Komturstrasse 18a,   D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz
Amtsgericht Muenchen: HRB161028


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to