Solved using this code! UNIQUE KEY `Index` (`uid` , `name`);
I need something like: UNIQUE (`cid`, `name`); Is that possible? Are you getting my point?
TID CID Name
1 1 Wordpress
2 1 Facebook
3 1 Facebook - This should not come!
4 2 Facebook - This is allowed
How does UNIQUE help in it? Because, another CID also can have the same Facebook Entry right? You got the logic?
Does InnoDB / MyISAM have...
How to create a candidate / super key using MySQL 5.1. I tried in internet, no use. :( Please help me out...
Its like this. I have tags table....
Separate names with a comma.