jp_like_utf8.result

来自「这个文件是windows mysql源码」· RESULT 代码 · 共 320 行

RESULT
320
字号
drop table if exists `T1`;drop table if exists `T2`;drop table if exists `T3`;drop table if exists `T4`;drop table if exists `T5`;drop table if exists `T6`;drop table if exists `T7`;drop table if exists `T8`;drop table if exists `T9`;drop table if exists `T10`;drop table if exists `T11`;drop table if exists `T12`;SET NAMES utf8;SET character_set_database = utf8;CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;CREATE TABLE `T2` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;CREATE TABLE `T10` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;CREATE TABLE `T11` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;CREATE TABLE `T12` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T10`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T11`;LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T12`;SELECT * FROM `T1` WHERE `C1` LIKE ' %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T1` WHERE `C1` LIKE '% %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T1` WHERE `C1` LIKE '% ';C1SELECT * FROM `T1` WHERE `C1` LIKE 'タ%';C1タチツテトナニヌネノハヒフヘホマSELECT * FROM `T1` WHERE `C1` LIKE '%ラリ%';C1ミムメモヤユヨラリルレロワン゙゚SELECT * FROM `T1` WHERE `C1` LIKE '%ソ';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T1` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T2` WHERE `C1` LIKE ' %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽSELECT * FROM `T2` WHERE `C1` LIKE '% %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽ・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T2` WHERE `C1` LIKE '% ';C1・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T2` WHERE `C1` LIKE 'と%';C1とどなにぬねのはばぱひびぴふぶぷへべぺほSELECT * FROM `T2` WHERE `C1` LIKE '%あ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T2` WHERE `C1` LIKE '%わ';C1ぼぽまみむめもゃやゅゆょよらりるれろゎわSELECT * FROM `T2` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T2` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T2` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T3` WHERE `C1` LIKE '鼫%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T3` WHERE `C1` LIKE '%鼺%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T3` WHERE `C1` LIKE '%齖';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T3` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T4` WHERE `C1` LIKE ' %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T4` WHERE `C1` LIKE '% %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T4` WHERE `C1` LIKE '% ';C1SELECT * FROM `T4` WHERE `C1` LIKE 'タ%';C1タチツテトナニヌネノハヒフヘホマSELECT * FROM `T4` WHERE `C1` LIKE '%ラリ%';C1ミムメモヤユヨラリルレロワン゙゚SELECT * FROM `T4` WHERE `C1` LIKE '%ソ';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T4` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T5` WHERE `C1` LIKE ' %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽSELECT * FROM `T5` WHERE `C1` LIKE '% %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽ・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T5` WHERE `C1` LIKE '% ';C1・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T5` WHERE `C1` LIKE 'と%';C1とどなにぬねのはばぱひびぴふぶぷへべぺほSELECT * FROM `T5` WHERE `C1` LIKE '%あ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T5` WHERE `C1` LIKE '%わ';C1ぼぽまみむめもゃやゅゆょよらりるれろゎわSELECT * FROM `T5` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T5` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T5` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T6` WHERE `C1` LIKE '鼫%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T6` WHERE `C1` LIKE '%鼺%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T6` WHERE `C1` LIKE '%齖';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T6` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T7` WHERE `C1` LIKE ' %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T7` WHERE `C1` LIKE '% %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T7` WHERE `C1` LIKE '% ';C1SELECT * FROM `T7` WHERE `C1` LIKE 'タ%';C1タチツテトナニヌネノハヒフヘホマSELECT * FROM `T7` WHERE `C1` LIKE '%ラリ%';C1ミムメモヤユヨラリルレロワン゙゚SELECT * FROM `T7` WHERE `C1` LIKE '%ソ';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T7` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T8` WHERE `C1` LIKE ' %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽSELECT * FROM `T8` WHERE `C1` LIKE '% %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽ・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T8` WHERE `C1` LIKE '% ';C1・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T8` WHERE `C1` LIKE 'と%';C1とどなにぬねのはばぱひびぴふぶぷへべぺほSELECT * FROM `T8` WHERE `C1` LIKE '%あ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T8` WHERE `C1` LIKE '%わ';C1ぼぽまみむめもゃやゅゆょよらりるれろゎわSELECT * FROM `T8` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T8` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T8` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T9` WHERE `C1` LIKE '鼫%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T9` WHERE `C1` LIKE '%鼺%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T9` WHERE `C1` LIKE '%齖';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T9` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T10` WHERE `C1` LIKE ' %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T10` WHERE `C1` LIKE '% %';C1 !"#$%&'()*+,-./ 。「」、・ヲァィゥェォャュョッSELECT * FROM `T10` WHERE `C1` LIKE '% ';C1SELECT * FROM `T10` WHERE `C1` LIKE 'タ%';C1タチツテトナニヌネノハヒフヘホマSELECT * FROM `T10` WHERE `C1` LIKE '%ラリ%';C1ミムメモヤユヨラリルレロワン゙゚SELECT * FROM `T10` WHERE `C1` LIKE '%ソ';C1ーアイウエオカキクケコサシスセソSELECT * FROM `T11` WHERE `C1` LIKE ' %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽSELECT * FROM `T11` WHERE `C1` LIKE '% %';C1  、。,.・:;?!゛゜´`¨^ ̄_ヽ・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T11` WHERE `C1` LIKE '% ';C1・・ʼn♯♭♪†‡¶・・・・◯・・・・ SELECT * FROM `T11` WHERE `C1` LIKE 'と%';C1とどなにぬねのはばぱひびぴふぶぷへべぺほSELECT * FROM `T11` WHERE `C1` LIKE '%あ%';C1・ぁあぃいぅうぇえぉおかがきぎくぐけげこSELECT * FROM `T11` WHERE `C1` LIKE '%わ';C1ぼぽまみむめもゃやゅゆょよらりるれろゎわSELECT * FROM `T12` WHERE `C1` LIKE '鼫%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T12` WHERE `C1` LIKE '%鼺%';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖SELECT * FROM `T12` WHERE `C1` LIKE '%齖';C1鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖DROP TABLE `T1`;DROP TABLE `T2`;DROP TABLE `T3`;DROP TABLE `T4`;DROP TABLE `T5`;DROP TABLE `T6`;DROP TABLE `T7`;DROP TABLE `T8`;DROP TABLE `T9`;DROP TABLE `T10`;DROP TABLE `T11`;DROP TABLE `T12`;

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?