#!/bin/sh /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicA.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'A%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicB.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'B%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicC.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'C%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicD.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'D%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicE.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'E%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicF.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'F%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicG.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'G%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicH.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'H%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicI.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'I%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicJ.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'J%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicK.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'K%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicL.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'L%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicM.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'M%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicN.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'N%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicO.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'O%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicP.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'P%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicQ.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'Q%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicR.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'R%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicS.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'S%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicT.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'T%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicU.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'U%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicV.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'V%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicW.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'W%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicX.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'X%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicY.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'Y%' ORDER BY Disease_En asc" TeXObGyDic /usr/local/mysql/bin/mysql -u root --password=synapse --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicZ.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'Z%' ORDER BY Disease_En asc" TeXObGyDic cd /usr/local/mysql/data/TeXObGyDic perl -w ./mod.pl ./DicA.txt > DicA.mod perl -w ./mod.pl ./DicB.txt > DicB.mod perl -w ./mod.pl ./DicC.txt > DicC.mod perl -w ./mod.pl ./DicD.txt > DicD.mod perl -w ./mod.pl ./DicE.txt > DicE.mod perl -w ./mod.pl ./DicF.txt > DicF.mod perl -w ./mod.pl ./DicG.txt > DicG.mod perl -w ./mod.pl ./DicH.txt > DicH.mod perl -w ./mod.pl ./DicI.txt > DicI.mod perl -w ./mod.pl ./DicJ.txt > DicJ.mod perl -w ./mod.pl ./DicK.txt > DicK.mod perl -w ./mod.pl ./DicL.txt > DicL.mod perl -w ./mod.pl ./DicM.txt > DicM.mod perl -w ./mod.pl ./DicN.txt > DicN.mod perl -w ./mod.pl ./DicO.txt > DicO.mod perl -w ./mod.pl ./DicP.txt > DicP.mod perl -w ./mod.pl ./DicQ.txt > DicQ.mod perl -w ./mod.pl ./DicR.txt > DicR.mod perl -w ./mod.pl ./DicS.txt > DicS.mod perl -w ./mod.pl ./DicT.txt > DicT.mod perl -w ./mod.pl ./DicU.txt > DicU.mod perl -w ./mod.pl ./DicV.txt > DicV.mod perl -w ./mod.pl ./DicW.txt > DicW.mod perl -w ./mod.pl ./DicX.txt > DicX.mod perl -w ./mod.pl ./DicY.txt > DicY.mod perl -w ./mod.pl ./DicZ.txt > DicZ.mod perl -w ./mySQLtoTeX.pl ./DicA.mod > DicA.tex perl -w ./mySQLtoTeX.pl ./DicB.mod > DicB.tex perl -w ./mySQLtoTeX.pl ./DicC.mod > DicC.tex perl -w ./mySQLtoTeX.pl ./DicD.mod > DicD.tex perl -w ./mySQLtoTeX.pl ./DicE.mod > DicE.tex perl -w ./mySQLtoTeX.pl ./DicF.mod > DicF.tex perl -w ./mySQLtoTeX.pl ./DicG.mod > DicG.tex perl -w ./mySQLtoTeX.pl ./DicH.mod > DicH.tex perl -w ./mySQLtoTeX.pl ./DicI.mod > DicI.tex perl -w ./mySQLtoTeX.pl ./DicJ.mod > DicJ.tex perl -w ./mySQLtoTeX.pl ./DicK.mod > DicK.tex perl -w ./mySQLtoTeX.pl ./DicL.mod > DicL.tex perl -w ./mySQLtoTeX.pl ./DicM.mod > DicM.tex perl -w ./mySQLtoTeX.pl ./DicN.mod > DicN.tex perl -w ./mySQLtoTeX.pl ./DicO.mod > DicO.tex perl -w ./mySQLtoTeX.pl ./DicP.mod > DicP.tex perl -w ./mySQLtoTeX.pl ./DicQ.mod > DicQ.tex perl -w ./mySQLtoTeX.pl ./DicR.mod > DicR.tex perl -w ./mySQLtoTeX.pl ./DicS.mod > DicS.tex perl -w ./mySQLtoTeX.pl ./DicT.mod > DicT.tex perl -w ./mySQLtoTeX.pl ./DicU.mod > DicU.tex perl -w ./mySQLtoTeX.pl ./DicV.mod > DicV.tex perl -w ./mySQLtoTeX.pl ./DicW.mod > DicW.tex perl -w ./mySQLtoTeX.pl ./DicX.mod > DicX.tex perl -w ./mySQLtoTeX.pl ./DicY.mod > DicY.tex perl -w ./mySQLtoTeX.pl ./DicZ.mod > DicZ.tex