
PFA...!!Please look at the table data carefully.
Table:
Code: Select all
CREATE TABLE IF NOT EXISTS `version` (
`nidt` varchar(11) NOT NULL,
`noeud` tinyint(3) NOT NULL,
`VERSION` float NOT NULL,
`ETAT_FONCT` varchar(20) default NULL,
`idnap` varchar(25) NOT NULL,
`nidtint` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1. If ETAT_FONCT = "OPERATIONAL" Delete REST ROWS EXCEPT HIGHEST Version
2. If ETAT_FONCT != "OPERATIONAL" DELETE Older verions
Thanks in advanced for input.
