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]