Jump to content

Multiple unique columns


sniperscope

Recommended Posts

Hi

is it possible to make multiple columns unique ?

Searched google but nothing found to use. I want something like below.

+ id + Column 1 + Column 2    +

| 1  | james      | 2009-08-10 |

| 2  | james      | 2009-08-11 |

| 3  | mike        | 2009-08-12 |

| 4  | mike        | 2009-08-12 | <-- ERROR

 

Regards

Link to comment
https://forums.phpfreaks.com/topic/170609-multiple-unique-columns/
Share on other sites

Why would you want the date to be unique? (as you can see it's giving you an error at the minute).

Dear aschk. Glad to your answer.

The place i pointed is where i want to get error.

So far i tried REPLACE INTO and IGNORE INTO but no chance. I want user can not insert data at same person, same date.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.