KTUGFaq
KTUG FAQ
Money will say more in one moment than the most eloquent lover can in years.
FrontPage › ObGyDic
- MakingDic . . . . 14 matches
06ObGyDic database¿¡´Â ¾à 3°³ÀÇ tableÀÌ ÇÊ¿äÇÒ °Í °°´Ù.
* ObGyDic_main table : ÁÖµÈ dic tableÀÌ´Ù. main_disease_id, ¿µ¾î Áúȯ¸í, ÇÑ±Û Áúȯ¸í, Á¤ÀÇ, Áúȯ¸í code, °¢ Áúȯ°ú °ü·ÃµÈ procedure code°¡ µé¾î °¡°Ô µÈ´Ù.
* ObGyDic_acce table : Áúȯ¸íÁß¿¡¼ Çü¿ë»ç(?)·Î µé¾î°¡´Â ºÎºÐÀ» ó¸®Çϱâ À§ÇÑ tableÀÌ´Ù. À§ÀÇ ObGyDic_main°ú °°Àº record°¡ µé¾î°¡¸ç, main_disease_id¸¦ ¿Ü·¡Å°(foreign key)·Î »ç¿ëÇÒ »ý°¢ÀÌ´Ù.(¿ì¼±Àº optional·Î µÎ±â·ÎÇÏ°Ú´Ù.)
1.±× ÈÄ¿¡ 06ObGyDic database¹× »ç¿ëÀÚ settingÇÑ´Ù
mysql>create database TeXObGyDic;
mysql>insert into db values ('localhost','TeXObGyDic','KTUG','y','y','y','y','y','y',
{{{#>/usr/local/mysql/bin/mysql -u KTUG -p TeXObGyDic
mysql>create table ObGyDic_main (
mysql>create table Admission_ObGyDic (
* Àú´Â óÀ½ÀÇ ¹æ¹ýÀ¸·Î ÇÏ¿´½À´Ï´Ù. ¹æ¹ýÀ¸·Î´Â load data infile '/usr/local/apache2/htdocs/0607TeXObGyDic.csv' into table ObGyDic_main fields terminated by ';' (Disease_En,Shortended_Word,Disease_Ko,Definition,Disease_Code,Procedure_Code); ÀÔ´Ï´Ù.
attachment:0603TeXObGyDic.csv
INTO OUTFILE 'DicA.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main