SELECT * FROM `tableauajustement`   WHERE codeGcAssureur='SAARPREV'
ORDER  BY ordre DESC


/*DELETE FROM `tableauajustement`   WHERE codeGcAssureur='SAARPREV'


UPDATE `tableauajustement` SET spMax='9999.99'   WHERE spMax='999.99'

TRUNCATE TABLE `tableauajustement`   */



INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '0', '45.99', '-0.15','SAARPREV', '1');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '46.00', '65.99', '-0.15','SAARPREV', '2');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '66.00', '70.99', '0','SAARPREV', '3');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '71.00', '80.99', '0.15','SAARPREV', '4');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '81.00', '90.99', '0.20','SAARPREV', '5');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '91.00', '100.99', '0.30','SAARPREV', '6');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '101.00', '110.99', '0.35','SAARPREV', '7');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '111.00', '115.99', '0.45','SAARPREV', '8');

INSERT INTO tableauajustement(`codeSociete`, `spMin`, `spMax`, `tauxAjustement`,codeGcAssureur, `ordre`)
VALUES	('vitalis', '116.00', '9999.99', '0.100','SAARPREV', '9');