0

I have a table with the following fields

id - (int) primary
project_id - (int)
post_id - (int)

I need to set it so that the post_id field is unique but only on a specific project id.

ie:

id || project_id || post_id

1     1             1
2     1             2
3     1             3
4     2             1
5     2             2
6     2             3

is this possible?

EDIT: I now have a new problem, sometimes the post_id field will be null, is there a way of using

      ALTER TABLE TableName
      ADD CONSTRAINT uc_PostProject UNIQUE (post_id,project_id)

But ignore null post_id's?

Tommy Arnold
  • 3,339
  • 8
  • 31
  • 40
  • 1
    possible duplicate of [How do I specify unique constraint for multiple columns in MySQL?](http://stackoverflow.com/questions/635937/how-do-i-specify-unique-constraint-for-multiple-columns-in-mysql) – saamorim Jul 12 '13 at 09:56
  • You want to alter table or you need a sql query? – mirkobrankovic Jul 12 '13 at 09:59

1 Answers1

0

Add the following

ALTER TABLE TableName
ADD CONSTRAINT uc_PostProject UNIQUE (post_id,project_id)

For more information see http://www.w3schools.com/sql/sql_unique.asp

saamorim
  • 3,855
  • 17
  • 22