[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:12113

From: Seiichi YANAI <Seiichi YANAI <yanai@xxxxxxxxxx>>
Date: Thu, 08 Sep 2005 16:27:12 +0900
Subject: [mysql 12113] Re: ¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ø¤Î½ÐÎϤηï

¤ä¤Ê¤¤¤Ç¤¹¡£
¥Õ¥¡¥¤¥ë̾¤ò¤Á¤ç¤Ã¤ÈÊѹ¹¤·¤Æ¤Þ¤¹¡£

¡ôwindows¤Î¥á¥âÄ¢¤Ï³ÈÄ¥»Ò¤ò.txt°Ê³°¤Ä¤±¤é¤ì¤ë¤«
¡ô¤É¤¦¤«¤ï¤«¤é¤Ê¤¯¤Ã¤Æ¡Ä


safe ¤µ¤ó¤Ï½ñ¤­¤Þ¤·¤¿:
>¤ªÃѤº¤«¤·¤¤¤Î¤Ç¤¹¤¬¡¢²¼µ­¤Îtest,sql¤Îºî¤êÊý¤¬
>ʬ¤«¤Ã¤Æ¤¤¤Þ¤»¤ó¡£

1.¤Þ¤º¡¢¥á¥âÄ¢¤òµ¯Æ°¤µ¤»¤Þ¤¹¡£
[¥¹¥¿¡¼¥È]¡Ý[Á´¤Æ¤Î¥×¥í¥°¥é¥à]¡Ý[¥¢¥¯¥»¥µ¥ê]¡Ý[¥á¥âÄ¢]

2.¥á¥âÄ¢¤Ë
use test;
show tables;

¤ÈÆþÎϤ·¤Æ¡¢c¥É¥é¥¤¥Ö¤Îľ²¼(c:\)¤Ëtestsql.txt¤È¤·¤ÆÊݸ¤·¤Þ¤¹¡£
*¤³¤³¤Ç¤ÏÎã¤È¤·¤Æc:\¤ËÊݸ¤·¤Æ¤¤¤Þ¤¹¤¬¡¢Ç¤°Õ¤Î¾ì½ê¤Ç¹½¤¤¤Þ¤»¤ó¡£
**£±¹ÔÌܤϤª»È¤¤¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î̾Á°¤ËÊѹ¹¤·¤Æ¤¯¤À¤µ¤¤¡£

3.¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤òµ¯Æ°¤·¤Þ¤¹¡£
[¥¹¥¿¡¼¥È]¡Ý[¥Õ¥¡¥¤¥ë̾¤ò»ØÄꤷ¤Æ¼Â¹Ô] 
ɽ¼¨¤µ¤ì¤¿¥Ü¥Ã¥¯¥¹¤Ë cmd ¤ÈÆþÎϤ·[OK]

4.mysql¥³¥Þ¥ó¥É¤ò°Ê²¼¤ÎÍͤËÆþÎϤ·¤Þ¤¹¡£
mysql -u ¥æ¡¼¥¶Ì¾ -p ¥Ñ¥¹¥ï¡¼¥É < c:\testsql.txt >c:\result.txt

*c:\testsql.txt¤Ï 2.¤ÇÊݸ¤·¤¿¥Õ¥¡¥¤¥ë¤Ç¤¹¡£°ã¤¦¾ì½ê¡¢°ã¤¦Ì¾Á°
¤ÇÊݸ¤·¤Æ¤¤¤ë¾ì¹ç¤ÏŬ»þÊѹ¹¤·¤Æ¤¯¤À¤µ¤¤

¤³¤ì¤Ç¡¢c¥É¥é¥¤¥Ö¤Îľ²¼(c:\)¤Ë·ë²Ì¤¬result.txt¤È¤¤¤¦Ì¾Á°¤Ç
ºîÀ®¤µ¤ì¤Þ¤¹¡£

¤³¤ì¤Ç¤É¤¦¤Ç¤·¤ç¤¦¡©

¡ô ÍÌ°æ À¿°ì (Seiichi YANAI)
¡ô e-mail:yanai@xxxxxxxxxx
¡ô MySQL for OS/2 ...

[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     12107 2005-09-08 10:04 ["safe" <geohase@xxxx] ¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ø¤Î½ÐÎÏ¤Î·ï            
     12108 2005-09-08 10:23 ¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                                       
     12109 2005-09-08 10:32 ¨±[Seiichi YANAI <yanai]                                       
     12111 2005-09-08 15:32 ¡¡¨±["safe" <geohase@xxxx]                                     
->   12113 2005-09-08 16:27 ¡¡¡¡¨²[Seiichi YANAI <yanai]                                   
     12118 2005-09-09 09:55 ¡¡¡¡¨­¨±["safe" <geohase@xxxx]                                 
     12115 2005-09-08 16:39 ¡¡¡¡¨±[SUGIMURA Takashi ¿ùÂ]                                   
     12116 2005-09-08 17:24 ¡¡¡¡¡¡¨²[Seiichi YANAI <yanai]                                 
     12123 2005-09-09 11:29 ¡¡¡¡¡¡¨±["safe" <geohase@xxxx]