1# 2# Testing multiple indexed UPDATE and DELETE 3# 4CREATE TABLE t1 ( 5id INT(4) NOT NULL, 6msg VARCHAR(16) NOT NULL, 7INDEX IDM(id,msg)) 8ENGINE=CONNECT TABLE_TYPE=DOS; 9Warnings: 10Warning 1105 No file name. Table will use t1.dos 11INSERT INTO t1 VALUES(1,'one'),(4, 'four'),(7,'seven'),(8,'eight'),(10,'ten'),(11,'eleven'),(40,'forty'),(35,'thirty five'),(60,'sixty'),(72,'seventy two'),(81,'eighty one'); 12INSERT INTO t1 VALUES(1,'un'),(4, 'quatre'),(7,'sept'),(8,'huit'),(10,'dix'),(11,'onze'),(40,'quarante'),(35,'trente cinq'),(60,'soixante'),(72,'soixante douze'),(81,'quatrevingt un'); 13SELECT * FROM t1 IGNORE INDEX (IDM); 14id msg 151 one 164 four 177 seven 188 eight 1910 ten 2011 eleven 2140 forty 2235 thirty five 2360 sixty 2472 seventy two 2581 eighty one 261 un 274 quatre 287 sept 298 huit 3010 dix 3111 onze 3240 quarante 3335 trente cinq 3460 soixante 3572 soixante douze 3681 quatrevingt un 37UPDATE t1 SET msg = 'dieci' WHERE id = 10; 38SELECT * FROM t1 IGNORE INDEX (IDM); 39id msg 401 one 414 four 427 seven 438 eight 4410 dieci 4511 eleven 4640 forty 4735 thirty five 4860 sixty 4972 seventy two 5081 eighty one 511 un 524 quatre 537 sept 548 huit 5510 dieci 5611 onze 5740 quarante 5835 trente cinq 5960 soixante 6072 soixante douze 6181 quatrevingt un 62UPDATE t1 SET msg = 'septante deux' WHERE id = 72; 63SELECT * FROM t1 IGNORE INDEX (IDM); 64id msg 651 one 664 four 677 seven 688 eight 6910 dieci 7011 eleven 7140 forty 7235 thirty five 7360 sixty 7472 septante deux 7581 eighty one 761 un 774 quatre 787 sept 798 huit 8010 dieci 8111 onze 8240 quarante 8335 trente cinq 8460 soixante 8572 septante deux 8681 quatrevingt un 87UPDATE t1 SET id=2, msg='deux' WHERE id=4 AND msg='quatre'; 88SELECT * FROM t1 IGNORE INDEX (IDM); 89id msg 901 one 914 four 927 seven 938 eight 9410 dieci 9511 eleven 9640 forty 9735 thirty five 9860 sixty 9972 septante deux 10081 eighty one 1011 un 1022 deux 1037 sept 1048 huit 10510 dieci 10611 onze 10740 quarante 10835 trente cinq 10960 soixante 11072 septante deux 11181 quatrevingt un 112DELETE FROM t1 WHERE id IN (8,40); 113SELECT * FROM t1 IGNORE INDEX (IDM); 114id msg 1151 one 1164 four 1177 seven 11810 dieci 11911 eleven 12035 thirty five 12160 sixty 12272 septante deux 12381 eighty one 1241 un 1252 deux 1267 sept 12710 dieci 12811 onze 12935 trente cinq 13060 soixante 13172 septante deux 13281 quatrevingt un 133DROP TABLE t1; 134