Database Design

[Anon]

I have a Database Table containing two three fields..
PID( unique, primary key, Number) , TestNoNumber),Status (String)

Insert a record: 1,1,Present : works fine.
Insert a record: 2,1,Present : works fine.
Insert a record: 1,2,Present : Conflict due to unique and primary kex field.

should I create another table and have a relation with the present table.. or any other better design ?

Thanking in advance

Sudhir.

[Anon]

Uh, I have a bit hard time understanding what you're trying to do.

Are you having a log of some tests in a table?

If so, then the primary key could be unique, so the last insert should be "insert 3, 2, present".

In MySQL you can specify the column as "auto increment" and leave the column as null in the insert query, so it automatically gets assigned a new unique id.

.samuli

[noremac]

I think your trying to insert a record with the same
id as the first. which is not possible if the that field is unique. as Samuli said if your using MySQL set your id field to auto_increment. (e.g. CREATE TABLE atable( id INT(10) DEFAULT NULL auto_increment, anumbrer INT10) NOT NULL, sometext CHAR(250), PRIMARY KEY(id) );