I have this mysql structure that its working fine for me and very simple..
I would like to know if its possible to create something so that it doesn't allow duplicates on (itockSymbol with iwhen) which is a timestamp
for example there is an insert USD and 1394647007306
and again another insert insert USD and 1394647007306 but dont allow it as it is a dup.
but if its AUD and 1394647007306 then its okay.
how can I do this?
CREATE TABLE IF NOT EXISTS `EURJPY` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itockSymbol` varchar(40) DEFAULT NULL,
`iwhen` varchar(20) DEFAULT NULL,
`ibuyValue` varchar(20) DEFAULT NULL,
`isellValue` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)