2
DROP TABLE IF EXISTS t1,t2,t3;
4
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
5
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
6
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
7
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
8
INSERT INTO t3 (c1) VALUES('a');
9
SELECT COUNT(c1) FROM t1;
10
DELETE FROM t1 WHERE c1 = 'a';
11
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
12
SELECT COUNT(c1) FROM t1;
14
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
15
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
16
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
17
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
18
INSERT INTO t3 (c1) VALUES('a');
19
SELECT COUNT(c1) FROM t1;
20
DELETE FROM t1 WHERE c1 = 'a';
21
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
22
SELECT COUNT(c1) FROM t1;
24
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
25
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
26
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
27
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
28
INSERT INTO t3 (c1) VALUES('a');
29
SELECT COUNT(c1) FROM t1;
30
DELETE FROM t1 WHERE c1 = 'a';
31
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
32
SELECT COUNT(c1) FROM t1;
34
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
35
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
36
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
37
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
38
INSERT INTO t3 (c1) VALUES('a');
39
SELECT COUNT(c1) FROM t1;
40
DELETE FROM t1 WHERE c1 = 'a';
41
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
42
SELECT COUNT(c1) FROM t1;
44
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
45
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
46
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
47
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
48
INSERT INTO t3 (c1) VALUES('a');
49
SELECT COUNT(c1) FROM t2;
50
DELETE FROM t2 WHERE c1 = 'a';
51
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
52
SELECT COUNT(c1) FROM t2;
54
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
55
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
56
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
57
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
58
INSERT INTO t3 (c1) VALUES('a');
59
SELECT COUNT(c1) FROM t2;
60
DELETE FROM t2 WHERE c1 = 'a';
61
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
62
SELECT COUNT(c1) FROM t2;
64
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
65
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
66
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
67
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
68
INSERT INTO t3 (c1) VALUES('a');
69
SELECT COUNT(c1) FROM t2;
70
DELETE FROM t2 WHERE c1 = 'a';
71
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
72
SELECT COUNT(c1) FROM t2;
74
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
75
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
76
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
77
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
78
INSERT INTO t3 (c1) VALUES('a');
79
SELECT COUNT(c1) FROM t2;
80
DELETE FROM t2 WHERE c1 = 'a';
81
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
82
SELECT COUNT(c1) FROM t2;
84
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
85
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
86
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
87
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
88
INSERT INTO t3 (c1) VALUES('a');
89
SELECT COUNT(c1) FROM t3;
90
DELETE FROM t3 WHERE c1 = 'a';
91
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
92
SELECT COUNT(c1) FROM t3;
94
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
95
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
96
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
97
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
98
INSERT INTO t3 (c1) VALUES('a');
99
SELECT COUNT(c1) FROM t3;
100
DELETE FROM t3 WHERE c1 = 'a';
101
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
102
SELECT COUNT(c1) FROM t3;
104
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
105
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
106
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
107
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
108
INSERT INTO t3 (c1) VALUES('a');
109
SELECT COUNT(c1) FROM t3;
110
DELETE FROM t3 WHERE c1 = 'a';
111
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
112
SELECT COUNT(c1) FROM t3;
114
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
115
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
116
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
117
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
118
INSERT INTO t3 (c1) VALUES('a');
119
SELECT COUNT(c1) FROM t3;
120
DELETE FROM t3 WHERE c1 = 'a';
121
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
122
SELECT COUNT(c1) FROM t3;
124
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
125
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
126
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
127
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
128
INSERT INTO t3 (c1) VALUES('a');
129
SELECT COUNT(c1) FROM t1;
130
DELETE FROM t1 WHERE c1 = 'b';
131
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
132
SELECT COUNT(c1) FROM t1;
134
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
135
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
136
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
137
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
138
INSERT INTO t3 (c1) VALUES('a');
139
SELECT COUNT(c1) FROM t1;
140
DELETE FROM t1 WHERE c1 = 'b';
141
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
142
SELECT COUNT(c1) FROM t1;
144
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
145
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
146
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
147
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
148
INSERT INTO t3 (c1) VALUES('a');
149
SELECT COUNT(c1) FROM t1;
150
DELETE FROM t1 WHERE c1 = 'b';
151
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
152
SELECT COUNT(c1) FROM t1;
154
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
155
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
156
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
157
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
158
INSERT INTO t3 (c1) VALUES('a');
159
SELECT COUNT(c1) FROM t1;
160
DELETE FROM t1 WHERE c1 = 'b';
161
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
162
SELECT COUNT(c1) FROM t1;
164
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
165
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
166
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
167
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
168
INSERT INTO t3 (c1) VALUES('a');
169
SELECT COUNT(c1) FROM t2;
170
DELETE FROM t2 WHERE c1 = 'b';
171
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
172
SELECT COUNT(c1) FROM t2;
174
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
175
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
176
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
177
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
178
INSERT INTO t3 (c1) VALUES('a');
179
SELECT COUNT(c1) FROM t2;
180
DELETE FROM t2 WHERE c1 = 'b';
181
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
182
SELECT COUNT(c1) FROM t2;
184
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
185
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
186
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
187
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
188
INSERT INTO t3 (c1) VALUES('a');
189
SELECT COUNT(c1) FROM t2;
190
DELETE FROM t2 WHERE c1 = 'b';
191
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
192
SELECT COUNT(c1) FROM t2;
194
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
195
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
196
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
197
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
198
INSERT INTO t3 (c1) VALUES('a');
199
SELECT COUNT(c1) FROM t2;
200
DELETE FROM t2 WHERE c1 = 'b';
201
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
202
SELECT COUNT(c1) FROM t2;
204
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
205
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
206
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
207
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
208
INSERT INTO t3 (c1) VALUES('a');
209
SELECT COUNT(c1) FROM t3;
210
DELETE FROM t3 WHERE c1 = 'b';
211
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
212
SELECT COUNT(c1) FROM t3;
214
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
215
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
216
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
217
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
218
INSERT INTO t3 (c1) VALUES('a');
219
SELECT COUNT(c1) FROM t3;
220
DELETE FROM t3 WHERE c1 = 'b';
221
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
222
SELECT COUNT(c1) FROM t3;
224
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
225
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
226
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
227
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
228
INSERT INTO t3 (c1) VALUES('a');
229
SELECT COUNT(c1) FROM t3;
230
DELETE FROM t3 WHERE c1 = 'b';
231
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
232
SELECT COUNT(c1) FROM t3;
234
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
235
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
236
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
237
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
238
INSERT INTO t3 (c1) VALUES('a');
239
SELECT COUNT(c1) FROM t3;
240
DELETE FROM t3 WHERE c1 = 'b';
241
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
242
SELECT COUNT(c1) FROM t3;
244
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
245
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
246
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
247
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
248
INSERT INTO t3 (c1) VALUES('a');
249
SELECT COUNT(c1) FROM t1;
250
DELETE FROM t1 WHERE c1 = 'c';
251
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
252
SELECT COUNT(c1) FROM t1;
254
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
255
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
256
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
257
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
258
INSERT INTO t3 (c1) VALUES('a');
259
SELECT COUNT(c1) FROM t1;
260
DELETE FROM t1 WHERE c1 = 'c';
261
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
262
SELECT COUNT(c1) FROM t1;
264
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
265
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
266
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
267
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
268
INSERT INTO t3 (c1) VALUES('a');
269
SELECT COUNT(c1) FROM t1;
270
DELETE FROM t1 WHERE c1 = 'c';
271
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
272
SELECT COUNT(c1) FROM t1;
274
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
275
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
276
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
277
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
278
INSERT INTO t3 (c1) VALUES('a');
279
SELECT COUNT(c1) FROM t1;
280
DELETE FROM t1 WHERE c1 = 'c';
281
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
282
SELECT COUNT(c1) FROM t1;
284
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
285
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
286
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
287
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
288
INSERT INTO t3 (c1) VALUES('a');
289
SELECT COUNT(c1) FROM t2;
290
DELETE FROM t2 WHERE c1 = 'c';
291
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
292
SELECT COUNT(c1) FROM t2;
294
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
295
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
296
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
297
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
298
INSERT INTO t3 (c1) VALUES('a');
299
SELECT COUNT(c1) FROM t2;
300
DELETE FROM t2 WHERE c1 = 'c';
301
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
302
SELECT COUNT(c1) FROM t2;
304
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
305
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
306
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
307
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
308
INSERT INTO t3 (c1) VALUES('a');
309
SELECT COUNT(c1) FROM t2;
310
DELETE FROM t2 WHERE c1 = 'c';
311
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
312
SELECT COUNT(c1) FROM t2;
314
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
315
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
316
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
317
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
318
INSERT INTO t3 (c1) VALUES('a');
319
SELECT COUNT(c1) FROM t2;
320
DELETE FROM t2 WHERE c1 = 'c';
321
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
322
SELECT COUNT(c1) FROM t2;
324
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
325
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
326
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
327
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
328
INSERT INTO t3 (c1) VALUES('a');
329
SELECT COUNT(c1) FROM t3;
330
DELETE FROM t3 WHERE c1 = 'c';
331
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
332
SELECT COUNT(c1) FROM t3;
334
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
335
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
336
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
337
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
338
INSERT INTO t3 (c1) VALUES('a');
339
SELECT COUNT(c1) FROM t3;
340
DELETE FROM t3 WHERE c1 = 'c';
341
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
342
SELECT COUNT(c1) FROM t3;
344
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
345
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
346
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
347
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
348
INSERT INTO t3 (c1) VALUES('a');
349
SELECT COUNT(c1) FROM t3;
350
DELETE FROM t3 WHERE c1 = 'c';
351
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
352
SELECT COUNT(c1) FROM t3;
354
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
355
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
356
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
357
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
358
INSERT INTO t3 (c1) VALUES('a');
359
SELECT COUNT(c1) FROM t3;
360
DELETE FROM t3 WHERE c1 = 'c';
361
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
362
SELECT COUNT(c1) FROM t3;
364
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
365
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
366
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
367
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
368
INSERT INTO t3 (c1) VALUES('a');
369
SELECT COUNT(c1) FROM t1;
370
DELETE FROM t1 WHERE c1 = 'd';
371
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
372
SELECT COUNT(c1) FROM t1;
374
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
375
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
376
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
377
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
378
INSERT INTO t3 (c1) VALUES('a');
379
SELECT COUNT(c1) FROM t1;
380
DELETE FROM t1 WHERE c1 = 'd';
381
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
382
SELECT COUNT(c1) FROM t1;
384
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
385
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
386
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
387
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
388
INSERT INTO t3 (c1) VALUES('a');
389
SELECT COUNT(c1) FROM t1;
390
DELETE FROM t1 WHERE c1 = 'd';
391
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
392
SELECT COUNT(c1) FROM t1;
394
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
395
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
396
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
397
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
398
INSERT INTO t3 (c1) VALUES('a');
399
SELECT COUNT(c1) FROM t1;
400
DELETE FROM t1 WHERE c1 = 'd';
401
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
402
SELECT COUNT(c1) FROM t1;
404
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
405
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
406
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
407
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
408
INSERT INTO t3 (c1) VALUES('a');
409
SELECT COUNT(c1) FROM t2;
410
DELETE FROM t2 WHERE c1 = 'd';
411
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
412
SELECT COUNT(c1) FROM t2;
414
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
415
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
416
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
417
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
418
INSERT INTO t3 (c1) VALUES('a');
419
SELECT COUNT(c1) FROM t2;
420
DELETE FROM t2 WHERE c1 = 'd';
421
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
422
SELECT COUNT(c1) FROM t2;
424
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
425
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
426
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
427
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
428
INSERT INTO t3 (c1) VALUES('a');
429
SELECT COUNT(c1) FROM t2;
430
DELETE FROM t2 WHERE c1 = 'd';
431
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
432
SELECT COUNT(c1) FROM t2;
434
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
435
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
436
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
437
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
438
INSERT INTO t3 (c1) VALUES('a');
439
SELECT COUNT(c1) FROM t2;
440
DELETE FROM t2 WHERE c1 = 'd';
441
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
442
SELECT COUNT(c1) FROM t2;
444
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
445
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
446
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
447
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
448
INSERT INTO t3 (c1) VALUES('a');
449
SELECT COUNT(c1) FROM t3;
450
DELETE FROM t3 WHERE c1 = 'd';
451
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
452
SELECT COUNT(c1) FROM t3;
454
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
455
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
456
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
457
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
458
INSERT INTO t3 (c1) VALUES('a');
459
SELECT COUNT(c1) FROM t3;
460
DELETE FROM t3 WHERE c1 = 'd';
461
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
462
SELECT COUNT(c1) FROM t3;
464
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
465
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
466
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
467
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
468
INSERT INTO t3 (c1) VALUES('a');
469
SELECT COUNT(c1) FROM t3;
470
DELETE FROM t3 WHERE c1 = 'd';
471
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
472
SELECT COUNT(c1) FROM t3;
474
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
475
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
476
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
477
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
478
INSERT INTO t3 (c1) VALUES('a');
479
SELECT COUNT(c1) FROM t3;
480
DELETE FROM t3 WHERE c1 = 'd';
481
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
482
SELECT COUNT(c1) FROM t3;