7
7
drop table if exists `�s�V`;
8
8
drop table if exists `�s�W`;
9
9
drop table if exists `�s�X`;
10
drop table if exists `�s�P�O`;
11
drop table if exists `�s�P�P`;
12
drop table if exists `�s�P�Q`;
14
11
SET character_set_database = sjis;
15
12
CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
18
15
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
19
16
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
20
17
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
21
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
22
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
23
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
24
CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
25
CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
26
CREATE TABLE `�s�P�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
18
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
19
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
20
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
27
21
INSERT INTO `�s�P` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
28
22
INSERT INTO `�s�Q` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
29
23
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
33
27
INSERT INTO `�s�V` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
34
28
INSERT INTO `�s�W` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
35
29
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
36
INSERT INTO `�s�P�O` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
37
INSERT INTO `�s�P�P` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
38
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
39
30
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P`;
40
31
�b�P RIGHT(`�b�P`,0)
471
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P�O`;
479
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�P�O`;
487
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�P�O`;
495
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�P�O`;
503
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�P�O`;
511
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�P�O`;
519
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P�P`;
527
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�P�P`;
535
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�P�P`;
543
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�P�P`;
551
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�P�P`;
559
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�P�P`;
561
���������� ����������
567
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P�Q`;
575
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�P�Q`;
583
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�P�Q`;
591
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�P�Q`;
599
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�P�Q`;
607
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�P�Q`;
609
�\�\�\�\�\ �\�\�\�\�\
615
462
DROP TABLE `�s�P`;
616
463
DROP TABLE `�s�Q`;
617
464
DROP TABLE `�s�R`;