1 echo CREATE TABLE T1
(f1 INT AUTO_INCREMENT
,f2 INT
);
3 echo INSERT INTO T1 values
(100,1);
4 Statement Executed
: Rows Affected
= 1
5 echo INSERT INTO T1
(f2
) values
(10);
6 Statement Executed
: Rows Affected
= 1
7 echo INSERT INTO T1
(f2
) values
(30);
8 Statement Executed
: Rows Affected
= 1
9 echo INSERT INTO T1
(f2
) values
(40);
10 Statement Executed
: Rows Affected
= 1
11 echo INSERT INTO T1
(f1
,f2
) values
(NULL
,40);
12 Statement Executed
: Rows Affected
= 1
13 echo INSERT INTO T1
(f1
,f2
) values
(100,40);
14 Statement execute failed with error
-21
15 echo SELECT
* FROM T1
;
16 ---------------------------------------------------------
18 ---------------------------------------------------------
25 echo CREATE TABLE T2
(f1 INT AUTO_INCREMENT
,f2 CHAR
(10));
27 echo INSERT INTO T2 values
(10,'Papu');
28 Statement Executed
: Rows Affected
= 1
29 echo INSERT INTO T2
(f2
) values
('Jitu');
30 Statement Executed
: Rows Affected
= 1
31 echo INSERT INTO T2
(f2
) values
('kishor');
32 Statement Executed
: Rows Affected
= 1
33 echo INSERT INTO T2
(f1
,f2
) values
(NULL
,'Nihar');
34 Statement Executed
: Rows Affected
= 1
35 echo INSERT INTO T2
(f1
,f2
) values
(100,'Suna');
36 Statement Executed
: Rows Affected
= 1
37 echo SELECT
* FROM T2
;
38 ---------------------------------------------------------
40 ---------------------------------------------------------
47 echo CREATE TABLE T3
(f1 CHAR
(10),f2 int auto_increment
);
49 echo INSERT INTO T3 values
('Papu',10);
50 Statement Executed
: Rows Affected
= 1
51 echo INSERT INTO T3
(f1
) values
('Jitu');
52 Statement Executed
: Rows Affected
= 1
53 echo INSERT INTO T3
(f1
) values
('kishor');
54 Statement Executed
: Rows Affected
= 1
55 echo INSERT INTO T3
(f1
,f2
) values
('Nihar',NULL
);
56 Statement Executed
: Rows Affected
= 1
57 echo INSERT INTO T3
(f2
,f1
) values
(100,NULL
);
58 Statement Executed
: Rows Affected
= 1
59 echo INSERT INTO T3
(f1
,f2
) values
(NULL
,NULL
);
60 Statement Executed
: Rows Affected
= 1
61 echo SELECT
* FROM T3
;
62 ---------------------------------------------------------
64 ---------------------------------------------------------
72 echo CREATE TABLE T4
(f1 INT AUTO_INCREMENT
,f2 INT
);
74 echo INSERT INTO T4 VALUES
(1,2);
75 Statement Executed
: Rows Affected
= 1
76 echo INSERT INTO T4 VALUES
(NULL
,2);
77 Statement Executed
: Rows Affected
= 1
78 echo INSERT INTO T4 VALUES
(NULL
,3);
79 Statement Executed
: Rows Affected
= 1
80 echo INSERT INTO T4 VALUES
(NULL
,2);
81 Statement Executed
: Rows Affected
= 1
82 echo INSERT INTO T4 VALUES
(NULL
,3);
83 Statement Executed
: Rows Affected
= 1
84 echo SELECT
* FROM T4
;
85 ---------------------------------------------------------
87 ---------------------------------------------------------
94 echo UPDATE T4 SET f2
=20 WHERE f2
=2;
95 Statement Executed
: Rows Affected
= 3
96 echo SELECT
* FROM T4
;
97 ---------------------------------------------------------
99 ---------------------------------------------------------
106 echo UPDATE T4 SET f2
=200,f1
=0 WHERE f2
=20;
107 Statement prepare failed with error
-33
108 echo SELECT
* FROM T4
;
109 ---------------------------------------------------------
111 ---------------------------------------------------------
118 echo UPDATE T4 SET f2
=300,f1
=30 WHERE f1
<=2;
119 Statement prepare failed with error
-33
120 echo SELECT
* FROM T4
;
121 ---------------------------------------------------------
123 ---------------------------------------------------------
130 echo CREATE TABLE T5
(f1 INT AUTO_INCREMENT
,f2 INT NOT NULL
);
132 echo INSERT INTO T5 VALUES
(NULL
,2);
133 Statement Executed
: Rows Affected
= 1
134 echo INSERT INTO T5 VALUES
(NULL
,NULL
);
135 Statement execute failed with error
-22
136 echo INSERT INTO T5 VALUES
(NULL
,3);
137 Statement Executed
: Rows Affected
= 1
138 echo INSERT INTO T5 VALUES
(NULL
,2);
139 Statement Executed
: Rows Affected
= 1
140 echo INSERT INTO T5 VALUES
(NULL
,3);
141 Statement Executed
: Rows Affected
= 1
142 echo SELECT
* FROM T5
;
143 ---------------------------------------------------------
145 ---------------------------------------------------------
151 echo DELETE FROM T5 WHERE f2
=2;
152 Statement Executed
: Rows Affected
= 2
153 echo SELECT
* FROM T5
;
154 ---------------------------------------------------------
156 ---------------------------------------------------------
161 echo SELECT
* FROM T5
;
162 ---------------------------------------------------------
164 ---------------------------------------------------------
168 echo DELETE FROM T5 WHERE f1
<=3 AND f1
!=2;
169 Statement Executed
: Rows Affected
= 1
170 echo SELECT
* FROM T5
;
171 ---------------------------------------------------------
173 ---------------------------------------------------------
176 echo INSERT INTO T5 VALUES
(3,30);
177 Statement Executed
: Rows Affected
= 1
178 echo SELECT
* FROM T5
;
179 ---------------------------------------------------------
181 ---------------------------------------------------------
186 Statement Executed
: Rows Affected
= 2
187 echo SELECT
* FROM T5
;
188 ---------------------------------------------------------
190 ---------------------------------------------------------
192 echo CREATE TABLE T6
(f1 INT AUTO_INCREMENT
,f2 INT
);
194 echo INSERT INTO T6 VALUES
(1,2);
195 Statement Executed
: Rows Affected
= 1
196 echo INSERT INTO T6 VALUES
(NULL
,2);
197 Statement Executed
: Rows Affected
= 1
198 echo INSERT INTO T6 VALUES
(NULL
,3);
199 Statement Executed
: Rows Affected
= 1
200 echo INSERT INTO T6 VALUES
(NULL
,2);
201 Statement Executed
: Rows Affected
= 1
202 echo INSERT INTO T6 VALUES
(NULL
,3);
203 Statement Executed
: Rows Affected
= 1
204 echo SELECT
* FROM T6
;
205 ---------------------------------------------------------
207 ---------------------------------------------------------
214 echo UPDATE T6 SET f2
=20 WHERE f2
=2;
215 Statement Executed
: Rows Affected
= 3
216 echo SELECT
* FROM T6
;
217 ---------------------------------------------------------
219 ---------------------------------------------------------
226 echo UPDATE T6 SET f2
=200,f1
=0 WHERE f2
=20;
227 Statement prepare failed with error
-33
228 echo SELECT
* FROM T6
;
229 ---------------------------------------------------------
231 ---------------------------------------------------------
238 echo UPDATE T6 SET f2
=300,f1
=30 WHERE f1
<=2;
239 Statement prepare failed with error
-33
240 echo SELECT
* FROM T6
;
241 ---------------------------------------------------------
243 ---------------------------------------------------------
250 echo DELETE FROM T6 WHERE f2
=2;
251 Statement Executed
: Rows Affected
= 0
252 echo SELECT
* FROM T6
;
253 ---------------------------------------------------------
255 ---------------------------------------------------------
263 echo SELECT
* FROM T6
;
264 ---------------------------------------------------------
266 ---------------------------------------------------------
273 echo DELETE FROM T6 WHERE f1
<=3 AND f1
!=2;
274 Statement Executed
: Rows Affected
= 2
275 echo SELECT
* FROM T6
;
276 ---------------------------------------------------------
278 ---------------------------------------------------------
283 echo INSERT INTO T6 VALUES
(3,30);
284 Statement Executed
: Rows Affected
= 1
285 echo SELECT
* FROM T6
;
286 ---------------------------------------------------------
288 ---------------------------------------------------------
295 Statement Executed
: Rows Affected
= 4
296 echo SELECT
* FROM T6
;
297 ---------------------------------------------------------
299 ---------------------------------------------------------
301 echo CREATE TABLE T7
(f1 INT AUTO_INCREMENT
,f2 INT
,f3 INT
);
303 echo INSERT INTO T7 VALUES
(1,2,3);
304 Statement Executed
: Rows Affected
= 1
305 echo SELECT
* FROM T7
;
306 ---------------------------------------------------------
308 ---------------------------------------------------------
311 echo UPDATE T7 SET f3
=30,f2
=20,f1
=0 where f1
=1;
312 Statement prepare failed with error
-33
313 echo UPDATE T7 SET f3
=30,f2
=20 where f1
=1;
314 Statement Executed
: Rows Affected
= 1
315 echo SELECT
* FROM T7
;
316 ---------------------------------------------------------
318 ---------------------------------------------------------
321 echo INSERT INTO T7 VALUES
(2,4,3);
322 Statement Executed
: Rows Affected
= 1
323 echo DELETE FROM T7 WHERE f3
<=3;
324 Statement Executed
: Rows Affected
= 1
325 echo CREATE TABLE T9
(f1 INT AUTO_INCREMENT
,f2 INT
,f3 INT
);
327 echo CREATE INDEX idx1 ON T9
(f1
,f2
) UNIQUE
;
329 echo INSERT INTO T9 VALUES
(1,2,3);
330 Statement Executed
: Rows Affected
= 1
331 echo SELECT
* FROM T9
;
332 ---------------------------------------------------------
334 ---------------------------------------------------------
337 echo UPDATE T9 SET f3
=30,f2
=20,f1
=0 where f1
=1;
338 Statement prepare failed with error
-21
339 echo UPDATE T9 SET f3
=30,f2
=20 where f1
=1;
340 Statement prepare failed with error
-21
341 echo SELECT
* FROM T9
;
342 ---------------------------------------------------------
344 ---------------------------------------------------------
347 echo INSERT INTO T9 VALUES
(2,4,3);
348 Statement Executed
: Rows Affected
= 1
349 echo DELETE FROM T9 WHERE f3
<=3;
350 Statement Executed
: Rows Affected
= 2
351 echo CREATE TABLE T10
(f1 INT AUTO_INCREMENT
,f2 INT
,f3 INT
,PRIMARY KEY
(f3
,f1
));
353 echo INSERT INTO T10 VALUES
(1,2,3);
354 Statement Executed
: Rows Affected
= 1
355 echo SELECT
* FROM T10
;
356 ---------------------------------------------------------
358 ---------------------------------------------------------
361 echo UPDATE T10 SET f3
=30,f2
=20,f1
=0 where f1
=1;
362 Statement prepare failed with error
-21
363 echo UPDATE T10 SET f3
=30,f2
=20 where f1
=1;
364 Statement prepare failed with error
-21
365 echo SELECT
* FROM T10
;
366 ---------------------------------------------------------
368 ---------------------------------------------------------
371 echo INSERT INTO T10 VALUES
(2,4,3);
372 Statement Executed
: Rows Affected
= 1
373 echo DELETE FROM T10 WHERE f3
<=3;
374 Statement Executed
: Rows Affected
= 2