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 Quote Link to comment 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). Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.