7
7
drop table if exists `�ԣ�`;
8
8
drop table if exists `�ԣ�`;
9
9
drop table if exists `�ԣ�`;
10
drop table if exists `�ԣ���`;
11
drop table if exists `�ԣ���`;
12
drop table if exists `�ԣ���`;
14
11
SET character_set_database = ujis;
15
12
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb;
202
199
DROP TABLE `�ԣ�` ;
203
200
DROP TABLE `�ԣ�` ;
204
201
DROP TABLE `�ԣ�` ;
205
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = HEAP;
206
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = HEAP;
207
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = HEAP;
208
INSERT INTO `�ԣ�` VALUES('��'),('��'),('��'),('��'),('���'),('���');
209
INSERT INTO `�ԣ�` VALUES('��'),('��'),('��'),('��'),('���'),('���');
210
INSERT INTO `�ԣ�` VALUES('��'),('��'),('��'),('��'),('���'),('���');
211
SELECT * FROM `�ԣ�` UNION DISTINCT SELECT * FROM `�ԣ�` ORDER BY `�ã�`;
219
SELECT * FROM `�ԣ�` UNION ALL SELECT * FROM `�ԣ�` ORDER BY `�ã�`;
233
(SELECT * FROM `�ԣ�`) UNION (SELECT * FROM `�ԣ�`) UNION (SELECT '��') ORDER BY `�ã�`;
242
(SELECT '��' AS `�ã�`) UNION (SELECT * FROM `�ԣ�`) UNION (SELECT * FROM `�ԣ�`) ORDER BY `�ã�`;
251
SELECT `�ã�`, COUNT(*) FROM `�ԣ�` GROUP BY `�ã�` UNION
252
SELECT `�ã�`, COUNT(*) FROM `�ԣ�` GROUP BY `�ã�` ORDER BY `�ã�`;
260
SELECT * FROM `�ԣ�` UNION DISTINCT
261
SELECT * FROM `�ԣ�` UNION ALL
262
SELECT * FROM `�ԣ�` ORDER BY `�ã�`;
276
SELECT * FROM `�ԣ�` UNION ALL
277
SELECT * FROM `�ԣ�` UNION DISTINCT
278
SELECT * FROM `�ԣ�` ORDER BY `�ã�`;
289
SELECT * FROM `�ԣ�` UNION SELECT REPEAT(`�ã�`,5) FROM `�ԣ�` ORDER BY `�ã�`;
300
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = BDB;
301
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = BDB;
302
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = BDB;
202
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
203
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
204
CREATE TABLE `�ԣ�` (`�ã�` char(1), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
303
205
INSERT INTO `�ԣ�` VALUES('��'),('��'),('��'),('��'),('���'),('���');
304
206
INSERT INTO `�ԣ�` VALUES('��'),('��'),('��'),('��'),('���'),('���');
305
207
INSERT INTO `�ԣ�` VALUES('��'),('��'),('��'),('��'),('���'),('���');