#!/bin/sh
for str in "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"
do
/usr/local/mysql/bin/mysql -u KTUG --password=KTUG1234 --execute="SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE './Dic@str.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE '@str%' ORDER BY Disease_En asc" TeXObGyDic
perl -w ./mySQLtoTeX.pl ./Dic@str.txt > ./Dic@str.tex
done