1 echo create table t1
(f1 int
);
3 echo create index idx1 on t1
(f1
);
5 echo insert into t1 values
(1);
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1 values
(3);
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1 values
(2);
10 Statement Executed
: Rows Affected
= 1
11 echo insert into t1 values
(11);
12 Statement Executed
: Rows Affected
= 1
13 echo insert into t1 values
(10);
14 Statement Executed
: Rows Affected
= 1
15 echo select * from t1
;
16 ---------------------------------------------------------
18 ---------------------------------------------------------
25 echo set autocommit off
;
26 AUTOCOMMIT Mode is
set to OFF
27 echo insert into t1 values
(8);
28 Statement Executed
: Rows Affected
= 1
29 echo insert into t1 values
(10);
30 Statement Executed
: Rows Affected
= 1
31 echo select * from t1
;
32 ---------------------------------------------------------
34 ---------------------------------------------------------
44 echo select * from t1
;
45 ---------------------------------------------------------
47 ---------------------------------------------------------
57 echo select * from t1
;
58 ---------------------------------------------------------
60 ---------------------------------------------------------
69 echo insert into t1 values
(12);
70 Statement Executed
: Rows Affected
= 1
71 echo insert into t1 values
(11);
72 Statement Executed
: Rows Affected
= 1
73 echo select * from t1
;
74 ---------------------------------------------------------
76 ---------------------------------------------------------
88 echo select * from t1
;
89 ---------------------------------------------------------
91 ---------------------------------------------------------
101 echo select * from t1
;
102 ---------------------------------------------------------
104 ---------------------------------------------------------
113 echo update t1
set f1
=15 where f1
=3;
114 Statement Executed
: Rows Affected
= 1
115 echo update t1
set f1
=11 where f1
=2;
116 Statement Executed
: Rows Affected
= 1
117 echo select * from t1
;
118 ---------------------------------------------------------
120 ---------------------------------------------------------
130 echo select * from t1
;
131 ---------------------------------------------------------
133 ---------------------------------------------------------
142 echo select * from t1 where f1
=3;
143 ---------------------------------------------------------
145 ---------------------------------------------------------
148 echo update t1
set f1
=30 where f1
=3;
149 Statement Executed
: Rows Affected
= 1
150 echo select * from t1
;
151 ---------------------------------------------------------
153 ---------------------------------------------------------
163 echo select * from t1
;
164 ---------------------------------------------------------
166 ---------------------------------------------------------
175 echo delete from t1 where f1
=30;
176 Statement Executed
: Rows Affected
= 1
177 echo select * from t1
;
178 ---------------------------------------------------------
180 ---------------------------------------------------------
188 echo delete from t1 where f1
=3;
189 Statement Executed
: Rows Affected
= 0
190 echo select * from t1
;
191 ---------------------------------------------------------
193 ---------------------------------------------------------
202 echo select * from t1
;
203 ---------------------------------------------------------
205 ---------------------------------------------------------
214 echo delete from t1 where f1
=30;
215 Statement Executed
: Rows Affected
= 1
216 echo select * from t1
;
217 ---------------------------------------------------------
219 ---------------------------------------------------------
227 echo delete from t1 where f1
=3;
228 Statement Executed
: Rows Affected
= 0
229 echo select * from t1
;
230 ---------------------------------------------------------
232 ---------------------------------------------------------
241 echo select * from t1
;
242 ---------------------------------------------------------
244 ---------------------------------------------------------
252 echo delete from t1 where f1
<=10;
253 Statement Executed
: Rows Affected
= 5
254 echo select * from t1
;
255 ---------------------------------------------------------
257 ---------------------------------------------------------
261 Statement Executed
: Rows Affected
= 1
263 echo select * from t1
;
264 ---------------------------------------------------------
266 ---------------------------------------------------------
271 echo create table t1
(f1 int
,f2 int
,f3 int
);
273 echo create index idx1 on t1
(f1
,f2
);
275 echo insert into t1 values
(1,10,100);
276 Statement Executed
: Rows Affected
= 1
277 echo insert into t1 values
(3,33,333);
278 Statement Executed
: Rows Affected
= 1
279 echo insert into t1 values
(2,33,444);
280 Statement Executed
: Rows Affected
= 1
281 echo set autocommit off
;
282 AUTOCOMMIT Mode is
set to OFF
283 echo insert into t1 values
(4,40,400);
284 Statement Executed
: Rows Affected
= 1
285 echo insert into t1 values
(3,33,333);
286 Statement Executed
: Rows Affected
= 1
287 echo select * from t1
;
288 ---------------------------------------------------------
290 ---------------------------------------------------------
298 echo select * from t1
;
299 ---------------------------------------------------------
301 ---------------------------------------------------------
307 echo select * from t1
;
308 ---------------------------------------------------------
310 ---------------------------------------------------------
315 echo insert into t1 values
(4,40,400);
316 Statement Executed
: Rows Affected
= 1
317 echo insert into t1 values
(3,33,333);
318 Statement Executed
: Rows Affected
= 1
319 echo select * from t1
;
320 ---------------------------------------------------------
322 ---------------------------------------------------------
330 echo select * from t1
;
331 ---------------------------------------------------------
333 ---------------------------------------------------------
341 echo select * from t1
;
342 ---------------------------------------------------------
344 ---------------------------------------------------------
351 echo update t1
set f1
=20 where f1
=2;
352 Statement Executed
: Rows Affected
= 1
353 echo select * from t1 where f1
=20;
354 ---------------------------------------------------------
356 ---------------------------------------------------------
359 echo update t1
set f2
=333 where f3
=444;
360 Statement Executed
: Rows Affected
= 1
361 echo select * from t1 where f3
=444;
362 ---------------------------------------------------------
364 ---------------------------------------------------------
367 echo select * from t1
;
368 ---------------------------------------------------------
370 ---------------------------------------------------------
377 echo update t1
set f1
=1,f2
=10 where f1
=20;
378 Statement Executed
: Rows Affected
= 1
379 echo select * from t1
;
380 ---------------------------------------------------------
382 ---------------------------------------------------------
390 echo select * from t1 where f1
=33;
391 ---------------------------------------------------------
393 ---------------------------------------------------------
395 echo select * from t1 where f1
=2;
396 ---------------------------------------------------------
398 ---------------------------------------------------------
401 echo select * from t1 where f1
=2 and f2
=33;
402 ---------------------------------------------------------
404 ---------------------------------------------------------
407 echo update t1
set f1
=20 where f1
=2;
408 Statement Executed
: Rows Affected
= 1
409 echo select * from t1 where f1
=20;
410 ---------------------------------------------------------
412 ---------------------------------------------------------
415 echo update t1
set f2
=333 where f3
=444;
416 Statement Executed
: Rows Affected
= 1
417 echo select * from t1
;
418 ---------------------------------------------------------
420 ---------------------------------------------------------
427 echo select * from t1 where f3
=444;
428 ---------------------------------------------------------
430 ---------------------------------------------------------
433 echo select * from t1
;
434 ---------------------------------------------------------
436 ---------------------------------------------------------
443 echo update t1
set f1
=1,f2
=10 where f1
=20;
444 Statement Executed
: Rows Affected
= 1
445 echo select * from t1
;
446 ---------------------------------------------------------
448 ---------------------------------------------------------
456 echo select *from t1
;
457 ---------------------------------------------------------
459 ---------------------------------------------------------
466 echo select * from t1 where f1
=1;
467 ---------------------------------------------------------
469 ---------------------------------------------------------
473 echo select * from t1 where f1
=2;
474 ---------------------------------------------------------
476 ---------------------------------------------------------
478 echo select * from t1 where f1
=2 and f2
=33;
479 ---------------------------------------------------------
481 ---------------------------------------------------------
483 echo select * from t1
;
484 ---------------------------------------------------------
486 ---------------------------------------------------------
493 echo delete from t1 where f1
=3 and f2
=33;
494 Statement Executed
: Rows Affected
= 2
495 echo select * from t1
;
496 ---------------------------------------------------------
498 ---------------------------------------------------------
503 echo delete from t1 where f1
in(1,5) and f2
in(50,10);
504 Statement Executed
: Rows Affected
= 2
505 echo select * from t1
;
506 ---------------------------------------------------------
508 ---------------------------------------------------------
511 echo delete from t1 where f2 between
33 and
45;
512 Statement Executed
: Rows Affected
= 1
513 echo select * from t1
;
514 ---------------------------------------------------------
516 ---------------------------------------------------------
519 Statement Executed
: Rows Affected
= 0
520 echo select * from t1
;
521 ---------------------------------------------------------
523 ---------------------------------------------------------
526 echo select * from t1
;
527 ---------------------------------------------------------
529 ---------------------------------------------------------
536 echo delete from t1 where f1
=3 and f2
=33;
537 Statement Executed
: Rows Affected
= 2
538 echo select * from t1
;
539 ---------------------------------------------------------
541 ---------------------------------------------------------
546 echo delete from t1 where f1
in(1,5) and f2
in(50,10);
547 Statement Executed
: Rows Affected
= 2
548 echo select * from t1
;
549 ---------------------------------------------------------
551 ---------------------------------------------------------
555 echo delete from t1 where f2 between
33 and
45;
556 Statement Executed
: Rows Affected
= 1
557 echo select * from t1
;
558 ---------------------------------------------------------
560 ---------------------------------------------------------
563 Statement Executed
: Rows Affected
= 0
564 echo select * from t1
;
565 ---------------------------------------------------------
567 ---------------------------------------------------------
569 echo select * from t1
;
570 ---------------------------------------------------------
572 ---------------------------------------------------------
577 echo create table t1
(f1 int
,f2 int
,f3 int
);
579 echo create index idx1 on t1
(f1
,f3
);
581 echo insert into t1 values
(1,10,100);
582 Statement Executed
: Rows Affected
= 1
583 echo insert into t1 values
(3,33,333);
584 Statement Executed
: Rows Affected
= 1
585 echo insert into t1 values
(2,33,444);
586 Statement Executed
: Rows Affected
= 1
587 echo set autocommit off
;
588 AUTOCOMMIT Mode is
set to OFF
589 echo insert into t1 values
(4,40,400);
590 Statement Executed
: Rows Affected
= 1
591 echo insert into t1 values
(3,33,333);
592 Statement Executed
: Rows Affected
= 1
593 echo select * from t1
;
594 ---------------------------------------------------------
596 ---------------------------------------------------------
604 echo select * from t1
;
605 ---------------------------------------------------------
607 ---------------------------------------------------------
613 echo select * from t1
;
614 ---------------------------------------------------------
616 ---------------------------------------------------------
621 echo insert into t1 values
(4,40,400);
622 Statement Executed
: Rows Affected
= 1
623 echo insert into t1 values
(3,33,333);
624 Statement Executed
: Rows Affected
= 1
625 echo select * from t1
;
626 ---------------------------------------------------------
628 ---------------------------------------------------------
636 echo select * from t1
;
637 ---------------------------------------------------------
639 ---------------------------------------------------------
647 echo select * from t1
;
648 ---------------------------------------------------------
650 ---------------------------------------------------------
657 echo update t1
set f1
=20 where f1
=2;
658 Statement Executed
: Rows Affected
= 1
659 echo select * from t1 where f1
=20;
660 ---------------------------------------------------------
662 ---------------------------------------------------------
665 echo update t1
set f2
=333 where f3
=444;
666 Statement Executed
: Rows Affected
= 1
667 echo select * from t1 where f3
=444;
668 ---------------------------------------------------------
670 ---------------------------------------------------------
673 echo select * from t1
;
674 ---------------------------------------------------------
676 ---------------------------------------------------------
683 echo update t1
set f1
=1,f2
=10 where f1
=20;
684 Statement Executed
: Rows Affected
= 1
685 echo select * from t1
;
686 ---------------------------------------------------------
688 ---------------------------------------------------------
696 echo select * from t1 where f1
=33;
697 ---------------------------------------------------------
699 ---------------------------------------------------------
701 echo select * from t1 where f1
=2;
702 ---------------------------------------------------------
704 ---------------------------------------------------------
707 echo select * from t1 where f1
=2 and f3
=444;
708 ---------------------------------------------------------
710 ---------------------------------------------------------
713 echo update t1
set f1
=20 where f1
=2;
714 Statement Executed
: Rows Affected
= 1
715 echo select * from t1 where f1
=20;
716 ---------------------------------------------------------
718 ---------------------------------------------------------
721 echo update t1
set f2
=333 where f3
=444;
722 Statement Executed
: Rows Affected
= 1
723 echo select * from t1
;
724 ---------------------------------------------------------
726 ---------------------------------------------------------
733 echo select * from t1 where f3
=444;
734 ---------------------------------------------------------
736 ---------------------------------------------------------
739 echo select * from t1
;
740 ---------------------------------------------------------
742 ---------------------------------------------------------
749 echo update t1
set f1
=1,f2
=10 where f1
=20;
750 Statement Executed
: Rows Affected
= 1
751 echo select * from t1
;
752 ---------------------------------------------------------
754 ---------------------------------------------------------
762 echo select *from t1
;
763 ---------------------------------------------------------
765 ---------------------------------------------------------
772 echo select * from t1 where f1
=1;
773 ---------------------------------------------------------
775 ---------------------------------------------------------
779 echo select * from t1 where f1
=2;
780 ---------------------------------------------------------
782 ---------------------------------------------------------
784 echo select * from t1 where f1
=2 and f3
=444;
785 ---------------------------------------------------------
787 ---------------------------------------------------------
789 echo select * from t1
;
790 ---------------------------------------------------------
792 ---------------------------------------------------------
799 echo delete from t1 where f1
=3 and f3
=333;
800 Statement Executed
: Rows Affected
= 2
801 echo select * from t1
;
802 ---------------------------------------------------------
804 ---------------------------------------------------------
809 echo delete from t1 where f1
in(1,5) and f3
in(50,100);
810 Statement Executed
: Rows Affected
= 1
811 echo select * from t1
;
812 ---------------------------------------------------------
814 ---------------------------------------------------------
818 echo delete from t1 where f2 between
33 and
45;
819 Statement Executed
: Rows Affected
= 1
820 echo select * from t1
;
821 ---------------------------------------------------------
823 ---------------------------------------------------------
827 Statement Executed
: Rows Affected
= 1
828 echo select * from t1
;
829 ---------------------------------------------------------
831 ---------------------------------------------------------
834 echo select * from t1
;
835 ---------------------------------------------------------
837 ---------------------------------------------------------
844 echo delete from t1 where f1
=3 and f3
=333;
845 Statement Executed
: Rows Affected
= 2
846 echo select * from t1
;
847 ---------------------------------------------------------
849 ---------------------------------------------------------
854 echo delete from t1 where f1
in(1,5) and f3
in(50,100);
855 Statement Executed
: Rows Affected
= 1
856 echo select * from t1
;
857 ---------------------------------------------------------
859 ---------------------------------------------------------
864 echo delete from t1 where f2 between
33 and
45;
865 Statement Executed
: Rows Affected
= 1
866 echo select * from t1
;
867 ---------------------------------------------------------
869 ---------------------------------------------------------
873 Statement Executed
: Rows Affected
= 1
874 echo select * from t1
;
875 ---------------------------------------------------------
877 ---------------------------------------------------------
879 echo select * from t1
;
880 ---------------------------------------------------------
882 ---------------------------------------------------------
887 echo create table t1
(f1 int
,f2 int
,f3 int
);
889 echo create index idx1 on t1
(f3
,f2
);
891 echo insert into t1 values
(1,10,100);
892 Statement Executed
: Rows Affected
= 1
893 echo insert into t1 values
(3,33,333);
894 Statement Executed
: Rows Affected
= 1
895 echo insert into t1 values
(2,33,444);
896 Statement Executed
: Rows Affected
= 1
897 echo set autocommit off
;
898 AUTOCOMMIT Mode is
set to OFF
899 echo insert into t1 values
(4,40,400);
900 Statement Executed
: Rows Affected
= 1
901 echo insert into t1 values
(3,33,333);
902 Statement Executed
: Rows Affected
= 1
903 echo select * from t1
;
904 ---------------------------------------------------------
906 ---------------------------------------------------------
914 echo select * from t1
;
915 ---------------------------------------------------------
917 ---------------------------------------------------------
923 echo select * from t1
;
924 ---------------------------------------------------------
926 ---------------------------------------------------------
931 echo insert into t1 values
(4,40,400);
932 Statement Executed
: Rows Affected
= 1
933 echo insert into t1 values
(3,33,333);
934 Statement Executed
: Rows Affected
= 1
935 echo select * from t1
;
936 ---------------------------------------------------------
938 ---------------------------------------------------------
946 echo select * from t1
;
947 ---------------------------------------------------------
949 ---------------------------------------------------------
957 echo select * from t1
;
958 ---------------------------------------------------------
960 ---------------------------------------------------------
967 echo update t1
set f1
=20 where f1
=2;
968 Statement Executed
: Rows Affected
= 1
969 echo select * from t1 where f1
=20;
970 ---------------------------------------------------------
972 ---------------------------------------------------------
975 echo update t1
set f2
=333 where f3
=444;
976 Statement Executed
: Rows Affected
= 1
977 echo select * from t1 where f3
=444;
978 ---------------------------------------------------------
980 ---------------------------------------------------------
983 echo select * from t1
;
984 ---------------------------------------------------------
986 ---------------------------------------------------------
993 echo update t1
set f1
=1,f2
=10 where f1
=20;
994 Statement Executed
: Rows Affected
= 1
995 echo select * from t1
;
996 ---------------------------------------------------------
998 ---------------------------------------------------------
1006 echo select * from t1 where f1
=33;
1007 ---------------------------------------------------------
1009 ---------------------------------------------------------
1011 echo select * from t1 where f1
=2;
1012 ---------------------------------------------------------
1014 ---------------------------------------------------------
1017 echo select * from t1 where f1
=2 and f2
=33;
1018 ---------------------------------------------------------
1020 ---------------------------------------------------------
1023 echo update t1
set f1
=20 where f1
=2;
1024 Statement Executed
: Rows Affected
= 1
1025 echo select * from t1 where f1
=20;
1026 ---------------------------------------------------------
1028 ---------------------------------------------------------
1031 echo update t1
set f2
=333 where f3
=444;
1032 Statement Executed
: Rows Affected
= 1
1033 echo select * from t1
;
1034 ---------------------------------------------------------
1036 ---------------------------------------------------------
1043 echo select * from t1 where f3
=444;
1044 ---------------------------------------------------------
1046 ---------------------------------------------------------
1049 echo select * from t1
;
1050 ---------------------------------------------------------
1052 ---------------------------------------------------------
1059 echo update t1
set f1
=1,f2
=10 where f1
=20;
1060 Statement Executed
: Rows Affected
= 1
1061 echo select * from t1
;
1062 ---------------------------------------------------------
1064 ---------------------------------------------------------
1072 echo select *from t1
;
1073 ---------------------------------------------------------
1075 ---------------------------------------------------------
1082 echo select * from t1 where f1
=1;
1083 ---------------------------------------------------------
1085 ---------------------------------------------------------
1089 echo select * from t1 where f1
=2;
1090 ---------------------------------------------------------
1092 ---------------------------------------------------------
1094 echo select * from t1 where f1
=2 and f2
=33;
1095 ---------------------------------------------------------
1097 ---------------------------------------------------------
1099 echo select * from t1
;
1100 ---------------------------------------------------------
1102 ---------------------------------------------------------
1109 echo delete from t1 where f3
=333 and f2
=33;
1110 Statement Executed
: Rows Affected
= 2
1111 echo select * from t1
;
1112 ---------------------------------------------------------
1114 ---------------------------------------------------------
1119 echo delete from t1 where f2
in(10,40) and f3
in(400,10);
1120 Statement Executed
: Rows Affected
= 1
1121 echo select * from t1
;
1122 ---------------------------------------------------------
1124 ---------------------------------------------------------
1128 echo delete from t1 where f2 between
33 and
45;
1129 Statement Executed
: Rows Affected
= 0
1130 echo select * from t1
;
1131 ---------------------------------------------------------
1133 ---------------------------------------------------------
1137 echo delete from t1
;
1138 Statement Executed
: Rows Affected
= 2
1139 echo select * from t1
;
1140 ---------------------------------------------------------
1142 ---------------------------------------------------------
1145 echo select * from t1
;
1146 ---------------------------------------------------------
1148 ---------------------------------------------------------
1155 echo delete from t1 where f3
=333 and f2
=33;
1156 Statement Executed
: Rows Affected
= 2
1157 echo select * from t1
;
1158 ---------------------------------------------------------
1160 ---------------------------------------------------------
1165 echo delete from t1 where f2
in(10,40) and f3
in(400,10);
1166 Statement Executed
: Rows Affected
= 1
1167 echo select * from t1
;
1168 ---------------------------------------------------------
1170 ---------------------------------------------------------
1175 echo delete from t1 where f2 between
33 and
45;
1176 Statement Executed
: Rows Affected
= 0
1177 echo select * from t1
;
1178 ---------------------------------------------------------
1180 ---------------------------------------------------------
1184 echo delete from t1
;
1185 Statement Executed
: Rows Affected
= 2
1186 echo select * from t1
;
1187 ---------------------------------------------------------
1189 ---------------------------------------------------------
1191 echo select * from t1
;
1192 ---------------------------------------------------------
1194 ---------------------------------------------------------