sniperscope Posted August 17, 2009 Share Posted August 17, 2009 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 More sharing options...
aschk Posted August 17, 2009 Share Posted August 17, 2009 Why would you want the date to be unique? (as you can see it's giving you an error at the minute). Link to comment https://forums.phpfreaks.com/topic/170609-multiple-unique-columns/#findComment-899878 Share on other sites More sharing options...
sniperscope Posted August 17, 2009 Author Share Posted August 17, 2009 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. Link to comment https://forums.phpfreaks.com/topic/170609-multiple-unique-columns/#findComment-899998 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.