2 echo CREATE TABLE T1
(f1 INT AUTO_INCREMENT
,f2 INT
);
4 echo INSERT INTO T1 values
(100,1);
5 Statement Executed
: Rows Affected
= 1
6 echo INSERT INTO T1
(f2
) values
(10);
7 Statement Executed
: Rows Affected
= 1
8 echo INSERT INTO T1
(f2
) values
(30);
9 Statement Executed
: Rows Affected
= 1
10 echo INSERT INTO T1
(f2
) values
(40);
11 Statement Executed
: Rows Affected
= 1
12 echo INSERT INTO T1
(f1
,f2
) values
(NULL
,40);
13 Statement Executed
: Rows Affected
= 1
14 echo INSERT INTO T1
(f1
,f2
) values
(100,40);
15 Statement execute failed with error
-21
16 echo SELECT
* FROM T1
;
17 ---------------------------------------------------------
19 ---------------------------------------------------------
26 echo CREATE TABLE T2
(f1 INT AUTO_INCREMENT
,f2 CHAR
(10));
28 echo INSERT INTO T2 values
(10,'Papu');
29 Statement Executed
: Rows Affected
= 1
30 echo INSERT INTO T2
(f2
) values
('Jitu');
31 Statement Executed
: Rows Affected
= 1
32 echo INSERT INTO T2
(f2
) values
('kishor');
33 Statement Executed
: Rows Affected
= 1
34 echo INSERT INTO T2
(f1
,f2
) values
(NULL
,'Nihar');
35 Statement Executed
: Rows Affected
= 1
36 echo INSERT INTO T2
(f1
,f2
) values
(100,'Suna');
37 Statement Executed
: Rows Affected
= 1
38 echo SELECT
* FROM T2
;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
48 echo CREATE TABLE T3
(f1 CHAR
(10),f2 int auto_increment
);
50 echo INSERT INTO T3 values
('Papu',10);
51 Statement Executed
: Rows Affected
= 1
52 echo INSERT INTO T3
(f1
) values
('Jitu');
53 Statement Executed
: Rows Affected
= 1
54 echo INSERT INTO T3
(f1
) values
('kishor');
55 Statement Executed
: Rows Affected
= 1
56 echo INSERT INTO T3
(f1
,f2
) values
('Nihar',NULL
);
57 Statement Executed
: Rows Affected
= 1
58 echo INSERT INTO T3
(f2
,f1
) values
(100,NULL
);
59 Statement Executed
: Rows Affected
= 1
60 echo INSERT INTO T3
(f1
,f2
) values
(NULL
,NULL
);
61 Statement Executed
: Rows Affected
= 1
62 echo SELECT
* FROM T3
;
63 ---------------------------------------------------------
65 ---------------------------------------------------------
73 echo CREATE TABLE T4
(f1 INT AUTO_INCREMENT
,f2 INT
);
75 echo INSERT INTO T4 VALUES
(1,2);
76 Statement Executed
: Rows Affected
= 1
77 echo INSERT INTO T4 VALUES
(NULL
,2);
78 Statement Executed
: Rows Affected
= 1
79 echo INSERT INTO T4 VALUES
(NULL
,3);
80 Statement Executed
: Rows Affected
= 1
81 echo INSERT INTO T4 VALUES
(NULL
,2);
82 Statement Executed
: Rows Affected
= 1
83 echo INSERT INTO T4 VALUES
(NULL
,3);
84 Statement Executed
: Rows Affected
= 1
85 echo SELECT
* FROM T4
;
86 ---------------------------------------------------------
88 ---------------------------------------------------------
95 echo UPDATE T4 SET f2
=20 WHERE f2
=2;
96 Statement Executed
: Rows Affected
= 3
97 echo SELECT
* FROM T4
;
98 ---------------------------------------------------------
100 ---------------------------------------------------------
107 echo UPDATE T4 SET f2
=200,f1
=0 WHERE f2
=20;
108 Statement prepare failed with error
-21
109 echo SELECT
* FROM T4
;
110 ---------------------------------------------------------
112 ---------------------------------------------------------
119 echo UPDATE T4 SET f2
=300,f1
=30 WHERE f1
<=2;
120 Statement prepare failed with error
-21
121 echo SELECT
* FROM T4
;
122 ---------------------------------------------------------
124 ---------------------------------------------------------
131 echo CREATE TABLE T5
(f1 INT AUTO_INCREMENT
,f2 INT NOT NULL
);
133 echo INSERT INTO T5 VALUES
(NULL
,2);
134 Statement Executed
: Rows Affected
= 1
135 echo INSERT INTO T5 VALUES
(NULL
,NULL
);
136 Statement execute failed with error
-22
137 echo INSERT INTO T5 VALUES
(NULL
,3);
138 Statement Executed
: Rows Affected
= 1
139 echo INSERT INTO T5 VALUES
(NULL
,2);
140 Statement Executed
: Rows Affected
= 1
141 echo INSERT INTO T5 VALUES
(NULL
,3);
142 Statement Executed
: Rows Affected
= 1
143 echo SELECT
* FROM T5
;
144 ---------------------------------------------------------
146 ---------------------------------------------------------
152 echo DELETE FROM T5 WHERE f2
=2;
153 Statement Executed
: Rows Affected
= 2
154 echo SELECT
* FROM T5
;
155 ---------------------------------------------------------
157 ---------------------------------------------------------
162 echo SELECT
* FROM T5
;
163 ---------------------------------------------------------
165 ---------------------------------------------------------
169 echo DELETE FROM T5 WHERE f1
<=3 AND f1
!=2;
170 Statement Executed
: Rows Affected
= 1
171 echo SELECT
* FROM T5
;
172 ---------------------------------------------------------
174 ---------------------------------------------------------
177 echo INSERT INTO T5 VALUES
(3,30);
178 Statement Executed
: Rows Affected
= 1
179 echo SELECT
* FROM T5
;
180 ---------------------------------------------------------
182 ---------------------------------------------------------
187 Statement Executed
: Rows Affected
= 2
188 echo SELECT
* FROM T5
;
189 ---------------------------------------------------------
191 ---------------------------------------------------------
193 echo CREATE TABLE T6
(f1 INT AUTO_INCREMENT
,f2 INT
);
195 echo INSERT INTO T6 VALUES
(1,2);
196 Statement Executed
: Rows Affected
= 1
197 echo INSERT INTO T6 VALUES
(NULL
,2);
198 Statement Executed
: Rows Affected
= 1
199 echo INSERT INTO T6 VALUES
(NULL
,3);
200 Statement Executed
: Rows Affected
= 1
201 echo INSERT INTO T6 VALUES
(NULL
,2);
202 Statement Executed
: Rows Affected
= 1
203 echo INSERT INTO T6 VALUES
(NULL
,3);
204 Statement Executed
: Rows Affected
= 1
205 echo SELECT
* FROM T6
;
206 ---------------------------------------------------------
208 ---------------------------------------------------------
215 echo UPDATE T6 SET f2
=20 WHERE f2
=2;
216 Statement Executed
: Rows Affected
= 3
217 echo SELECT
* FROM T6
;
218 ---------------------------------------------------------
220 ---------------------------------------------------------
227 echo UPDATE T6 SET f2
=200,f1
=0 WHERE f2
=20;
228 Statement prepare failed with error
-21
229 echo SELECT
* FROM T6
;
230 ---------------------------------------------------------
232 ---------------------------------------------------------
239 echo UPDATE T6 SET f2
=300,f1
=30 WHERE f1
<=2;
240 Statement prepare failed with error
-21
241 echo SELECT
* FROM T6
;
242 ---------------------------------------------------------
244 ---------------------------------------------------------
251 echo DELETE FROM T6 WHERE f2
=2;
252 Statement Executed
: Rows Affected
= 0
253 echo SELECT
* FROM T6
;
254 ---------------------------------------------------------
256 ---------------------------------------------------------
264 echo SELECT
* FROM T6
;
265 ---------------------------------------------------------
267 ---------------------------------------------------------
274 echo DELETE FROM T6 WHERE f1
<=3 AND f1
!=2;
275 Statement Executed
: Rows Affected
= 2
276 echo SELECT
* FROM T6
;
277 ---------------------------------------------------------
279 ---------------------------------------------------------
284 echo INSERT INTO T6 VALUES
(3,30);
285 Statement Executed
: Rows Affected
= 1
286 echo SELECT
* FROM T6
;
287 ---------------------------------------------------------
289 ---------------------------------------------------------
296 Statement Executed
: Rows Affected
= 4
297 echo SELECT
* FROM T6
;
298 ---------------------------------------------------------
300 ---------------------------------------------------------
302 echo CREATE TABLE T7
(f1 INT AUTO_INCREMENT
,f2 INT
,f3 INT
);
304 echo INSERT INTO T7 VALUES
(1,2,3);
305 Statement Executed
: Rows Affected
= 1
306 echo SELECT
* FROM T7
;
307 ---------------------------------------------------------
309 ---------------------------------------------------------
312 echo UPDATE T7 SET f3
=30,f2
=20,f1
=0 where f1
=1;
313 Statement prepare failed with error
-21
314 echo UPDATE T7 SET f3
=30,f2
=20 where f1
=1;
315 Statement Executed
: Rows Affected
= 1
316 echo SELECT
* FROM T7
;
317 ---------------------------------------------------------
319 ---------------------------------------------------------
322 echo INSERT INTO T7 VALUES
(2,4,3);
323 Statement Executed
: Rows Affected
= 1
324 echo DELETE FROM T7 WHERE f3
<=3;
325 Statement Executed
: Rows Affected
= 1
326 echo CREATE TABLE T9
(f1 INT AUTO_INCREMENT
,f2 INT
,f3 INT
);
328 echo CREATE INDEX idx1 ON T9
(f1
,f2
) UNIQUE
;
330 echo INSERT INTO T9 VALUES
(1,2,3);
331 Statement Executed
: Rows Affected
= 1
332 echo SELECT
* FROM T9
;
333 ---------------------------------------------------------
335 ---------------------------------------------------------
338 echo UPDATE T9 SET f3
=30,f2
=20,f1
=0 where f1
=1;
339 Statement prepare failed with error
-21
340 echo UPDATE T9 SET f3
=30,f2
=20 where f1
=1;
341 Statement prepare failed with error
-21
342 echo SELECT
* FROM T9
;
343 ---------------------------------------------------------
345 ---------------------------------------------------------
348 echo INSERT INTO T9 VALUES
(2,4,3);
349 Statement Executed
: Rows Affected
= 1
350 echo DELETE FROM T9 WHERE f3
<=3;
351 Statement Executed
: Rows Affected
= 2
352 echo CREATE TABLE T10
(f1 INT AUTO_INCREMENT
,f2 INT
,f3 INT
,PRIMARY KEY
(f3
,f1
));
354 echo INSERT INTO T10 VALUES
(1,2,3);
355 Statement Executed
: Rows Affected
= 1
356 echo SELECT
* FROM T10
;
357 ---------------------------------------------------------
359 ---------------------------------------------------------
362 echo UPDATE T10 SET f3
=30,f2
=20,f1
=0 where f1
=1;
363 Statement prepare failed with error
-21
364 echo UPDATE T10 SET f3
=30,f2
=20 where f1
=1;
365 Statement prepare failed with error
-21
366 echo SELECT
* FROM T10
;
367 ---------------------------------------------------------
369 ---------------------------------------------------------
372 echo INSERT INTO T10 VALUES
(2,4,3);
373 Statement Executed
: Rows Affected
= 1
374 echo DELETE FROM T10 WHERE f3
<=3;
375 Statement Executed
: Rows Affected
= 2