[anacy_nivas]

I have a table to save data about game players, Table like following
------------------------------------------------------------------------------------------
Id: 1 {Primary Key}
Name: ABU
Points: 20
Type: GAME1
TIME: 2:10
------------------------------------------------------------------------------------------
Id: 2 {primary Key}
Name: ABU
Points: 10
Type: GAME2
TIME: 2:30
----------------------------------------------------------------------------------------------

above table i need to set the unique id for column "Name" , but it based on column name "Type". It is possible?

[Golith]

above table i need to set the unique id for column "Name" , but it based on column name "Type". It is possible?

Not sure what your actually requiring ..

but if u set field : name to unique then there can only be one entry by a player with that name.. is this what u were looking for?