반응형
자신의 그룹에 맞는값 가져오기 (no_1,no_2,no_3,no_4)
DROP TABLE IF EXISTS `TB_A`;
CREATE TABLE `TB_A` (
`no_1` int(11) NOT NULL default '0',
`no_2` int(11) NOT NULL default '0',
`no_3` int(11) NOT NULL default '0',
`no_4` int(11) NOT NULL default '0',
`title` char(50) NOT NULL default '',
PRIMARY KEY (`no_1`,`no_2`,`no_3`,`no_4`)
) type=myisam DEFAULT CHARSET=euckr;
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,0,0,0,'하나1000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,0,0,'하나1100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,0,'하나1110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,1,'하나1111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,2,'하나1112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,3,'하나1113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,0,'하나1120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,1,'하나1121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,2,'하나1122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,3,'하나1123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,0,'하나1130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,1,'하나1131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,2,'하나1132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,3,'하나1133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,0,0,'하나1200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,0,'하나1210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,1,'하나1211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,2,'하나1212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,3,'하나1213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,0,'하나1220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,1,'하나1221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,2,'하나1222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,3,'하나1223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,0,'하나1230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,1,'하나1231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,2,'하나1232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,3,'하나1233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,0,0,'하나1300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,0,'하나1310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,1,'하나1311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,2,'하나1312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,3,'하나1313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,0,'하나1320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,1,'하나1321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,2,'하나1322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,3,'하나1323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,0,'하나1330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,1,'하나1331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,2,'하나1332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,3,'하나1333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,0,0,0,'둘2000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,0,0,'둘2100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,0,'둘2110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,1,'둘2111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,2,'둘2112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,3,'둘2113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,0,'둘2120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,1,'둘2121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,2,'둘2122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,3,'둘2123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,0,'둘2130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,1,'둘2131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,2,'둘2132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,3,'둘2133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,0,0,'둘2200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,0,'둘2210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,1,'둘2211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,2,'둘2212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,3,'둘2213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,0,'둘2220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,1,'둘2221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,2,'둘2222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,3,'둘2223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,0,'둘2230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,1,'둘2231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,2,'둘2232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,3,'둘2233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,0,0,'둘2300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,0,'둘2310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,1,'둘2311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,2,'둘2312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,3,'둘2313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,0,'둘2320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,1,'둘2321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,2,'둘2322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,3,'둘2323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,0,'둘2330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,1,'둘2331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,2,'둘2332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,3,'둘2333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,0,0,0,'셋3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,0,0,'셋3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,0,'셋3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,1,'셋3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,2,'셋3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,3,'셋3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,0,'셋3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,1,'셋3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,2,'셋3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,3,'셋3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,0,'셋3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,1,'셋3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,2,'셋3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,3,'셋3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,0,0,'셋3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,0,'셋3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,1,'셋3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,2,'셋3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,3,'셋3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,0,'셋3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,1,'셋3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,2,'셋3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,3,'셋3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,0,'셋3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,1,'셋3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,2,'셋3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,3,'셋3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,0,0,'셋3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,0,'셋3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,1,'셋3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,2,'셋3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,3,'셋3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,0,'셋3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,1,'셋3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,2,'셋3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,3,'셋3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,0,'셋3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,1,'셋3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,2,'셋3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,3,'셋3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,0,0,0,'넷3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,0,0,'넷3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,0,'넷3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,1,'넷3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,2,'넷3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,3,'넷3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,0,'넷3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,1,'넷3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,2,'넷3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,3,'넷3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,0,'넷3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,1,'넷3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,2,'넷3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,3,'넷3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,0,0,'넷3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,0,'넷3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,1,'넷3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,2,'넷3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,3,'넷3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,0,'넷3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,1,'넷3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,2,'넷3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,3,'넷3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,0,'넷3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,1,'넷3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,2,'넷3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,3,'넷3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,0,0,'넷3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,0,'넷3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,1,'넷3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,2,'넷3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,3,'넷3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,0,'넷3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,1,'넷3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,2,'넷3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,3,'넷3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,0,'넷3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,1,'넷3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,2,'넷3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,3,'넷3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,0,0,0,'다섯3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,0,0,'다섯3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,0,'다섯3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,1,'다섯3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,2,'다섯3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,3,'다섯3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,0,'다섯3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,1,'다섯3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,2,'다섯3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,3,'다섯3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,0,'다섯3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,1,'다섯3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,2,'다섯3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,3,'다섯3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,0,0,'다섯3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,0,'다섯3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,1,'다섯3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,2,'다섯3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,3,'다섯3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,0,'다섯3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,1,'다섯3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,2,'다섯3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,3,'다섯3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,0,'다섯3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,1,'다섯3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,2,'다섯3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,3,'다섯3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,0,0,'다섯3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,0,'다섯3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,1,'다섯3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,2,'다섯3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,3,'다섯3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,0,'다섯3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,1,'다섯3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,2,'다섯3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,3,'다섯3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,0,'다섯3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,1,'다섯3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,2,'다섯3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,3,'다섯3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,0,0,0,'여섯3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,0,0,'여섯3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,0,'여섯3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,1,'여섯3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,2,'여섯3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,3,'여섯3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,0,'여섯3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,1,'여섯3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,2,'여섯3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,3,'여섯3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,0,'여섯3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,1,'여섯3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,2,'여섯3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,3,'여섯3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,0,0,'여섯3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,0,'여섯3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,1,'여섯3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,2,'여섯3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,3,'여섯3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,0,'여섯3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,1,'여섯3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,2,'여섯3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,3,'여섯3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,0,'여섯3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,1,'여섯3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,2,'여섯3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,3,'여섯3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,0,0,'여섯3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,0,'여섯3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,1,'여섯3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,2,'여섯3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,3,'여섯3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,0,'여섯3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,1,'여섯3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,2,'여섯3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,3,'여섯3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,0,'여섯3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,1,'여섯3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,2,'여섯3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,3,'여섯3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,0,0,0,'일곱3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,0,0,'일곱3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,0,'일곱3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,1,'일곱3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,2,'일곱3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,3,'일곱3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,0,'일곱3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,1,'일곱3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,2,'일곱3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,3,'일곱3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,0,'일곱3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,1,'일곱3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,2,'일곱3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,3,'일곱3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,0,0,'일곱3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,0,'일곱3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,1,'일곱3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,2,'일곱3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,3,'일곱3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,0,'일곱3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,1,'일곱3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,2,'일곱3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,3,'일곱3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,0,'일곱3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,1,'일곱3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,2,'일곱3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,3,'일곱3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,0,0,'일곱3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,0,'일곱3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,1,'일곱3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,2,'일곱3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,3,'일곱3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,0,'일곱3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,1,'일곱3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,2,'일곱3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,3,'일곱3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,0,'일곱3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,1,'일곱3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,2,'일곱3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,3,'일곱3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,0,0,0,'여덜3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,0,0,'여덜3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,0,'여덜3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,1,'여덜3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,2,'여덜3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,3,'여덜3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,0,'여덜3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,1,'여덜3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,2,'여덜3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,3,'여덜3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,0,'여덜3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,1,'여덜3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,2,'여덜3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,3,'여덜3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,0,0,'여덜3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,0,'여덜3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,1,'여덜3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,2,'여덜3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,3,'여덜3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,0,'여덜3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,1,'여덜3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,2,'여덜3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,3,'여덜3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,0,'여덜3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,1,'여덜3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,2,'여덜3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,3,'여덜3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,0,0,'여덜3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,0,'여덜3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,1,'여덜3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,2,'여덜3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,3,'여덜3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,0,'여덜3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,1,'여덜3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,2,'여덜3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,3,'여덜3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,0,'여덜3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,1,'여덜3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,2,'여덜3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,3,'여덜3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,0,0,0,'아홉3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,0,0,'아홉3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,0,'아홉3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,1,'아홉3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,2,'아홉3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,3,'아홉3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,0,'아홉3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,1,'아홉3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,2,'아홉3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,3,'아홉3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,0,'아홉3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,1,'아홉3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,2,'아홉3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,3,'아홉3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,0,0,'아홉3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,0,'아홉3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,1,'아홉3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,2,'아홉3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,3,'아홉3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,0,'아홉3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,1,'아홉3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,2,'아홉3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,3,'아홉3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,0,'아홉3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,1,'아홉3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,2,'아홉3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,3,'아홉3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,0,0,'아홉3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,0,'아홉3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,1,'아홉3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,2,'아홉3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,3,'아홉3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,0,'아홉3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,1,'아홉3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,2,'아홉3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,3,'아홉3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,0,'아홉3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,1,'아홉3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,2,'아홉3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,3,'아홉3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,0,0,0,'열+하나1000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,0,0,'열+하나1100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,0,'열+하나1110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,1,'열+하나1111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,2,'열+하나1112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,3,'열+하나1113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,0,'열+하나1120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,1,'열+하나1121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,2,'열+하나1122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,3,'열+하나1123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,0,'열+하나1130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,1,'열+하나1131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,2,'열+하나1132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,3,'열+하나1133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,0,0,'열+하나1200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,0,'열+하나1210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,1,'열+하나1211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,2,'열+하나1212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,3,'열+하나1213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,0,'열+하나1220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,1,'열+하나1221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,2,'열+하나1222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,3,'열+하나1223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,0,'열+하나1230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,1,'열+하나1231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,2,'열+하나1232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,3,'열+하나1233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,0,0,'열+하나1300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,0,'열+하나1310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,1,'열+하나1311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,2,'열+하나1312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,3,'열+하나1313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,0,'열+하나1320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,1,'열+하나1321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,2,'열+하나1322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,3,'열+하나1323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,0,'열+하나1330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,1,'열+하나1331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,2,'열+하나1332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,3,'열+하나1333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,0,0,0,'열+둘2000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,0,0,'열+둘2100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,0,'열+둘2110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,1,'열+둘2111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,2,'열+둘2112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,3,'열+둘2113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,0,'열+둘2120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,1,'열+둘2121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,2,'열+둘2122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,3,'열+둘2123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,0,'열+둘2130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,1,'열+둘2131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,2,'열+둘2132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,3,'열+둘2133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,0,0,'열+둘2200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,0,'열+둘2210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,1,'열+둘2211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,2,'열+둘2212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,3,'열+둘2213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,0,'열+둘2220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,1,'열+둘2221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,2,'열+둘2222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,3,'열+둘2223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,0,'열+둘2230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,1,'열+둘2231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,2,'열+둘2232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,3,'열+둘2233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,0,0,'열+둘2300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,0,'열+둘2310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,1,'열+둘2311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,2,'열+둘2312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,3,'열+둘2313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,0,'열+둘2320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,1,'열+둘2321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,2,'열+둘2322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,3,'열+둘2323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,0,'열+둘2330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,1,'열+둘2331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,2,'열+둘2332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,3,'열+둘2333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,0,0,0,'열+셋3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,0,0,'열+셋3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,0,'열+셋3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,1,'열+셋3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,2,'열+셋3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,3,'열+셋3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,0,'열+셋3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,1,'열+셋3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,2,'열+셋3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,3,'열+셋3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,0,'열+셋3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,1,'열+셋3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,2,'열+셋3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,3,'열+셋3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,0,0,'열+셋3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,0,'열+셋3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,1,'열+셋3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,2,'열+셋3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,3,'열+셋3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,0,'열+셋3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,1,'열+셋3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,2,'열+셋3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,3,'열+셋3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,0,'열+셋3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,1,'열+셋3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,2,'열+셋3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,3,'열+셋3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,0,0,'열+셋3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,0,'열+셋3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,1,'열+셋3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,2,'열+셋3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,3,'열+셋3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,0,'열+셋3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,1,'열+셋3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,2,'열+셋3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,3,'열+셋3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,0,'열+셋3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,1,'열+셋3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,2,'열+셋3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,3,'열+셋3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,0,0,0,'열+넷3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,0,0,'열+넷3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,1,0,'열+넷3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,1,1,'열+넷3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,1,2,'열+넷3112');
-- 추출 쿼리 입니다.
select
*
,
case when no_1>0 and no_2=0 and no_3=0 and no_4=0 then
title
when no_1>0 and no_2>0 and no_3=0 and no_4=0 then
concat(
(select title from TB_A B where A.no_1=B.no_1 and B.no_2=0 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and B.no_3=0 and B.no_4=0)
)
when no_1>0 and no_2>0 and no_3>0 and no_4=0 then
concat(
(select title from TB_A B where A.no_1=B.no_1 and B.no_2=0 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and A.no_3=B.no_3 and B.no_4=0)
)
when no_1>0 and no_2>0 and no_3>0 and no_4>0 then
concat(
(select title from TB_A B where A.no_1=B.no_1 and B.no_2=0 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and A.no_3=B.no_3 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and A.no_3=B.no_3 and A.no_4=B.no_4)
)
else "오류"
end t_title
from TB_A A
-- limit 100
DROP TABLE IF EXISTS `TB_A`;
CREATE TABLE `TB_A` (
`no_1` int(11) NOT NULL default '0',
`no_2` int(11) NOT NULL default '0',
`no_3` int(11) NOT NULL default '0',
`no_4` int(11) NOT NULL default '0',
`title` char(50) NOT NULL default '',
PRIMARY KEY (`no_1`,`no_2`,`no_3`,`no_4`)
) type=myisam DEFAULT CHARSET=euckr;
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,0,0,0,'하나1000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,0,0,'하나1100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,0,'하나1110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,1,'하나1111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,2,'하나1112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,1,3,'하나1113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,0,'하나1120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,1,'하나1121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,2,'하나1122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,2,3,'하나1123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,0,'하나1130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,1,'하나1131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,2,'하나1132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,1,3,3,'하나1133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,0,0,'하나1200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,0,'하나1210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,1,'하나1211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,2,'하나1212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,1,3,'하나1213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,0,'하나1220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,1,'하나1221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,2,'하나1222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,2,3,'하나1223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,0,'하나1230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,1,'하나1231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,2,'하나1232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,2,3,3,'하나1233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,0,0,'하나1300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,0,'하나1310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,1,'하나1311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,2,'하나1312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,1,3,'하나1313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,0,'하나1320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,1,'하나1321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,2,'하나1322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,2,3,'하나1323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,0,'하나1330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,1,'하나1331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,2,'하나1332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (1,3,3,3,'하나1333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,0,0,0,'둘2000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,0,0,'둘2100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,0,'둘2110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,1,'둘2111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,2,'둘2112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,1,3,'둘2113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,0,'둘2120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,1,'둘2121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,2,'둘2122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,2,3,'둘2123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,0,'둘2130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,1,'둘2131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,2,'둘2132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,1,3,3,'둘2133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,0,0,'둘2200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,0,'둘2210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,1,'둘2211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,2,'둘2212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,1,3,'둘2213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,0,'둘2220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,1,'둘2221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,2,'둘2222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,2,3,'둘2223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,0,'둘2230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,1,'둘2231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,2,'둘2232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,2,3,3,'둘2233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,0,0,'둘2300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,0,'둘2310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,1,'둘2311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,2,'둘2312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,1,3,'둘2313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,0,'둘2320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,1,'둘2321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,2,'둘2322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,2,3,'둘2323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,0,'둘2330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,1,'둘2331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,2,'둘2332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (2,3,3,3,'둘2333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,0,0,0,'셋3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,0,0,'셋3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,0,'셋3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,1,'셋3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,2,'셋3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,1,3,'셋3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,0,'셋3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,1,'셋3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,2,'셋3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,2,3,'셋3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,0,'셋3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,1,'셋3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,2,'셋3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,1,3,3,'셋3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,0,0,'셋3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,0,'셋3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,1,'셋3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,2,'셋3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,1,3,'셋3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,0,'셋3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,1,'셋3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,2,'셋3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,2,3,'셋3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,0,'셋3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,1,'셋3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,2,'셋3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,2,3,3,'셋3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,0,0,'셋3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,0,'셋3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,1,'셋3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,2,'셋3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,1,3,'셋3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,0,'셋3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,1,'셋3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,2,'셋3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,2,3,'셋3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,0,'셋3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,1,'셋3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,2,'셋3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (3,3,3,3,'셋3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,0,0,0,'넷3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,0,0,'넷3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,0,'넷3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,1,'넷3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,2,'넷3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,1,3,'넷3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,0,'넷3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,1,'넷3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,2,'넷3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,2,3,'넷3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,0,'넷3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,1,'넷3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,2,'넷3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,1,3,3,'넷3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,0,0,'넷3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,0,'넷3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,1,'넷3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,2,'넷3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,1,3,'넷3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,0,'넷3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,1,'넷3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,2,'넷3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,2,3,'넷3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,0,'넷3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,1,'넷3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,2,'넷3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,2,3,3,'넷3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,0,0,'넷3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,0,'넷3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,1,'넷3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,2,'넷3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,1,3,'넷3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,0,'넷3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,1,'넷3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,2,'넷3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,2,3,'넷3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,0,'넷3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,1,'넷3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,2,'넷3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (4,3,3,3,'넷3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,0,0,0,'다섯3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,0,0,'다섯3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,0,'다섯3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,1,'다섯3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,2,'다섯3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,1,3,'다섯3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,0,'다섯3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,1,'다섯3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,2,'다섯3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,2,3,'다섯3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,0,'다섯3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,1,'다섯3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,2,'다섯3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,1,3,3,'다섯3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,0,0,'다섯3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,0,'다섯3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,1,'다섯3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,2,'다섯3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,1,3,'다섯3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,0,'다섯3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,1,'다섯3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,2,'다섯3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,2,3,'다섯3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,0,'다섯3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,1,'다섯3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,2,'다섯3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,2,3,3,'다섯3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,0,0,'다섯3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,0,'다섯3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,1,'다섯3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,2,'다섯3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,1,3,'다섯3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,0,'다섯3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,1,'다섯3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,2,'다섯3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,2,3,'다섯3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,0,'다섯3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,1,'다섯3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,2,'다섯3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (5,3,3,3,'다섯3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,0,0,0,'여섯3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,0,0,'여섯3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,0,'여섯3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,1,'여섯3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,2,'여섯3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,1,3,'여섯3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,0,'여섯3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,1,'여섯3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,2,'여섯3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,2,3,'여섯3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,0,'여섯3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,1,'여섯3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,2,'여섯3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,1,3,3,'여섯3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,0,0,'여섯3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,0,'여섯3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,1,'여섯3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,2,'여섯3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,1,3,'여섯3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,0,'여섯3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,1,'여섯3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,2,'여섯3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,2,3,'여섯3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,0,'여섯3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,1,'여섯3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,2,'여섯3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,2,3,3,'여섯3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,0,0,'여섯3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,0,'여섯3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,1,'여섯3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,2,'여섯3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,1,3,'여섯3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,0,'여섯3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,1,'여섯3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,2,'여섯3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,2,3,'여섯3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,0,'여섯3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,1,'여섯3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,2,'여섯3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (6,3,3,3,'여섯3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,0,0,0,'일곱3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,0,0,'일곱3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,0,'일곱3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,1,'일곱3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,2,'일곱3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,1,3,'일곱3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,0,'일곱3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,1,'일곱3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,2,'일곱3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,2,3,'일곱3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,0,'일곱3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,1,'일곱3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,2,'일곱3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,1,3,3,'일곱3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,0,0,'일곱3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,0,'일곱3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,1,'일곱3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,2,'일곱3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,1,3,'일곱3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,0,'일곱3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,1,'일곱3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,2,'일곱3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,2,3,'일곱3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,0,'일곱3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,1,'일곱3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,2,'일곱3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,2,3,3,'일곱3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,0,0,'일곱3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,0,'일곱3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,1,'일곱3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,2,'일곱3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,1,3,'일곱3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,0,'일곱3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,1,'일곱3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,2,'일곱3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,2,3,'일곱3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,0,'일곱3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,1,'일곱3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,2,'일곱3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (7,3,3,3,'일곱3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,0,0,0,'여덜3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,0,0,'여덜3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,0,'여덜3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,1,'여덜3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,2,'여덜3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,1,3,'여덜3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,0,'여덜3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,1,'여덜3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,2,'여덜3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,2,3,'여덜3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,0,'여덜3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,1,'여덜3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,2,'여덜3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,1,3,3,'여덜3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,0,0,'여덜3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,0,'여덜3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,1,'여덜3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,2,'여덜3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,1,3,'여덜3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,0,'여덜3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,1,'여덜3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,2,'여덜3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,2,3,'여덜3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,0,'여덜3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,1,'여덜3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,2,'여덜3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,2,3,3,'여덜3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,0,0,'여덜3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,0,'여덜3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,1,'여덜3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,2,'여덜3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,1,3,'여덜3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,0,'여덜3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,1,'여덜3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,2,'여덜3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,2,3,'여덜3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,0,'여덜3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,1,'여덜3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,2,'여덜3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (8,3,3,3,'여덜3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,0,0,0,'아홉3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,0,0,'아홉3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,0,'아홉3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,1,'아홉3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,2,'아홉3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,1,3,'아홉3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,0,'아홉3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,1,'아홉3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,2,'아홉3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,2,3,'아홉3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,0,'아홉3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,1,'아홉3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,2,'아홉3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,1,3,3,'아홉3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,0,0,'아홉3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,0,'아홉3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,1,'아홉3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,2,'아홉3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,1,3,'아홉3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,0,'아홉3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,1,'아홉3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,2,'아홉3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,2,3,'아홉3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,0,'아홉3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,1,'아홉3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,2,'아홉3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,2,3,3,'아홉3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,0,0,'아홉3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,0,'아홉3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,1,'아홉3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,2,'아홉3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,1,3,'아홉3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,0,'아홉3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,1,'아홉3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,2,'아홉3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,2,3,'아홉3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,0,'아홉3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,1,'아홉3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,2,'아홉3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (9,3,3,3,'아홉3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,0,0,0,'열+하나1000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,0,0,'열+하나1100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,0,'열+하나1110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,1,'열+하나1111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,2,'열+하나1112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,1,3,'열+하나1113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,0,'열+하나1120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,1,'열+하나1121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,2,'열+하나1122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,2,3,'열+하나1123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,0,'열+하나1130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,1,'열+하나1131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,2,'열+하나1132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,1,3,3,'열+하나1133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,0,0,'열+하나1200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,0,'열+하나1210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,1,'열+하나1211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,2,'열+하나1212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,1,3,'열+하나1213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,0,'열+하나1220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,1,'열+하나1221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,2,'열+하나1222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,2,3,'열+하나1223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,0,'열+하나1230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,1,'열+하나1231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,2,'열+하나1232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,2,3,3,'열+하나1233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,0,0,'열+하나1300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,0,'열+하나1310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,1,'열+하나1311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,2,'열+하나1312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,1,3,'열+하나1313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,0,'열+하나1320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,1,'열+하나1321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,2,'열+하나1322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,2,3,'열+하나1323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,0,'열+하나1330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,1,'열+하나1331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,2,'열+하나1332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (11,3,3,3,'열+하나1333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,0,0,0,'열+둘2000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,0,0,'열+둘2100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,0,'열+둘2110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,1,'열+둘2111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,2,'열+둘2112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,1,3,'열+둘2113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,0,'열+둘2120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,1,'열+둘2121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,2,'열+둘2122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,2,3,'열+둘2123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,0,'열+둘2130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,1,'열+둘2131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,2,'열+둘2132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,1,3,3,'열+둘2133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,0,0,'열+둘2200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,0,'열+둘2210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,1,'열+둘2211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,2,'열+둘2212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,1,3,'열+둘2213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,0,'열+둘2220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,1,'열+둘2221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,2,'열+둘2222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,2,3,'열+둘2223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,0,'열+둘2230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,1,'열+둘2231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,2,'열+둘2232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,2,3,3,'열+둘2233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,0,0,'열+둘2300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,0,'열+둘2310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,1,'열+둘2311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,2,'열+둘2312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,1,3,'열+둘2313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,0,'열+둘2320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,1,'열+둘2321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,2,'열+둘2322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,2,3,'열+둘2323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,0,'열+둘2330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,1,'열+둘2331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,2,'열+둘2332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (12,3,3,3,'열+둘2333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,0,0,0,'열+셋3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,0,0,'열+셋3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,0,'열+셋3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,1,'열+셋3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,2,'열+셋3112');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,1,3,'열+셋3113');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,0,'열+셋3120');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,1,'열+셋3121');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,2,'열+셋3122');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,2,3,'열+셋3123');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,0,'열+셋3130');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,1,'열+셋3131');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,2,'열+셋3132');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,1,3,3,'열+셋3133');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,0,0,'열+셋3200');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,0,'열+셋3210');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,1,'열+셋3211');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,2,'열+셋3212');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,1,3,'열+셋3213');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,0,'열+셋3220');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,1,'열+셋3221');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,2,'열+셋3222');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,2,3,'열+셋3223');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,0,'열+셋3230');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,1,'열+셋3231');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,2,'열+셋3232');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,2,3,3,'열+셋3233');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,0,0,'열+셋3300');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,0,'열+셋3310');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,1,'열+셋3311');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,2,'열+셋3312');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,1,3,'열+셋3313');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,0,'열+셋3320');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,1,'열+셋3321');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,2,'열+셋3322');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,2,3,'열+셋3323');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,0,'열+셋3330');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,1,'열+셋3331');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,2,'열+셋3332');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (13,3,3,3,'열+셋3333');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,0,0,0,'열+넷3000');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,0,0,'열+넷3100');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,1,0,'열+넷3110');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,1,1,'열+넷3111');
insert into TB_A (no_1, no_2, no_3, no_4,title) values (14,1,1,2,'열+넷3112');
-- 추출 쿼리 입니다.
select
*
,
case when no_1>0 and no_2=0 and no_3=0 and no_4=0 then
title
when no_1>0 and no_2>0 and no_3=0 and no_4=0 then
concat(
(select title from TB_A B where A.no_1=B.no_1 and B.no_2=0 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and B.no_3=0 and B.no_4=0)
)
when no_1>0 and no_2>0 and no_3>0 and no_4=0 then
concat(
(select title from TB_A B where A.no_1=B.no_1 and B.no_2=0 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and A.no_3=B.no_3 and B.no_4=0)
)
when no_1>0 and no_2>0 and no_3>0 and no_4>0 then
concat(
(select title from TB_A B where A.no_1=B.no_1 and B.no_2=0 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and B.no_3=0 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and A.no_3=B.no_3 and B.no_4=0)
,"=>"
,(select title from TB_A B where A.no_1=B.no_1 and A.no_2=B.no_2 and A.no_3=B.no_3 and A.no_4=B.no_4)
)
else "오류"
end t_title
from TB_A A
-- limit 100
반응형