mysql:3636
From: "MINOHATA Norio" <"MINOHATA Norio" <minohata@xxxxxxxxxx>>
Date: Thu, 17 May 2001 11:05:29 +0900
Subject: [mysql 03636] ÉâÆ°¾®¿ô¤¬¥Ç¥¿¥é¥á¤Ê¿ôÃͤ˲½¤±¤Æ½ÐÎϤµ¤ì¤ë¥Ð¥°
ÉâÆ°¾®¿ô¤Ë´Ø¤¹¤ë¥Ð¥°¤òȯ¸«¤·¤Þ¤·¤¿¡£ (´Ä¶) FreeBSD4.2 MySQL3.23.37, 3.23.38 configure --prefix=/usr/local/mysql --with-charset=ujis (¾É¾õ) select * from tableA into outfile 'sample1.txt'; select * from tableA into outfile 'sample2.txt'; ¤Î¤è¤¦¤ËÁ´¤¯Æ±¤¸¥Æ¡¼¥Ö¥ë¤ò2²ó¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤ·¤Æ diff sample1.txt sample2.txt ¤Çº¹Ê¬¤ò¤È¤ë¤ÈÉâÆ°¾®¿ô¤Î¹àÌܤ¬°ìÃפ·¤Ê¤¤¤È¤¤¤¦¸½¾Ý¤¬È¯À¸¤·¤Þ¤·¤¿¡£ 10Ëü¥ì¥³¡¼¥É¤Î¥Õ¥¡¥¤¥ë¤ÇÉÔ°ìÃפ¬1·ï¡Á2·ïÄøÅ٤Ǥ¹¡£ (ÉÔ°ìÃפÎÎã) 12355.25 ¤¬ 63355.25 ¤Ë¤Ê¤ë¡£<---¾å°Ì·å¤¬¥Ç¥¿¥é¥á¤Ë¤Ê¤ë 12355.25 ¤¬ 12355. ¤Ë¤Ê¤ë¡£<---¾®¿ôÅÀ°Ê²¼¤¬¾Ã¤¨¤ë ¤³¤Î¾É¾õ¤¬¤Ç¤¿´Ä¶¤Ç¤Ï¡¢Æ±»þÀܳ¿ô¤¬10¸ÄÄøÅÙ¤Ç 1ʬ¤¢¤¿¤ê100¡Á200ÄøÅ٤Υ¯¥¨¥ê¡¼¤¬¼Â¹Ô¤µ¤ì¤Æ¤¤¤Þ¤¹¡£ Ê̤Υƥ¹¥ÈÍѴĶ¤Ë¥Æ¡¼¥Ö¥ë¤ò¥³¥Ô¡¼¤·¤ÆƱ¤¸Áàºî¤ò»î¤·¤Æ¤¿½ê¡¢ select ... into outfile ... ¤ò¼Â¹ÔÃæ¤Ë¡¢ÊÌ¥¹¥ì¥Ã¥É¤Ç¾¤Î¥¯¥¨¥ê¡¼¤¬ ¼Â¹Ô¤µ¤ì¤¿¾ì¹ç¤Ë¤³¤Î¾É¾õ¤¬È¯À¸¤¹¤ë¤é¤·¤¤¤È¤¤¤¦¤³¤È¤¬¤ï¤«¤ê¤Þ¤·¤¿¡£ ¤Þ¤¿¡¢ºÇ½é¤Ï¥Ç¡¼¥¿·¿¤Ë float(10,2) ¤ò»È¤Ã¤Æ¤¤¤¿¤Î¤Ç¤¹¤¬¡¢ ¤³¤ì¤ò double ¤ä real ¤ËÊѹ¹¤·¤Æ¤âƱ¤¸¾É¾õ¤¬È¯À¸¤·¤Þ¤·¤¿¡£ ÉÔ°ìÃפΥѥ¿¡¼¥ó¤â¤¢¤ï¤»¤Æ¹Í¤¨¤Æ¤ß¤Þ¤¹¤È¡¢ÉâÆ°¾®¿ô¤ò¥¢¥¹¥¡¼Ê¸»úÎó¤Ë ÊÑ´¹¤¹¤ë¥ë¡¼¥Á¥ó¤¬¥¹¥ì¥Ã¥É¥»¡¼¥Õ¤Ë¤Ê¤Ã¤Æ¤¤¤Ê¤¤¤è¤¦¤Êµ¤¤¬¤·¤Þ¤¹¡£ # °ì»þÊÑ¿ô¤ò¥¹¥ì¥Ã¥É´Ö¤Ç¶¦Í¤·¤Æ¤·¤Þ¤Ã¤Æ¤¤¤ë¡© ¤È¤ê¤¢¤¨¤º¡¢»ä¤ÎÎϤdzÎǧ¤Ç¤¤¿¤Î¤Ï¤³¤³¤Þ¤Ç¤Ç¤¹¡£ (¥½¡¼¥¹¥³¡¼¥É¤òÄÉÀפ¹¤ëǽÎϤ¬¤¢¤ê¤Þ¤»¤ó¤Î¤Ç) -- ̧ȪŵÃË minohata@xxxxxxxxxx
-> 3636 2001-05-17 11:05 ["MINOHATA Norio" <mi] ÉâÆ°¾®¿ô¤¬¥Ç¥¿¥é¥á¤Ê¿ôÃͤ˲½¤±¤Æ½ÐÎϤµ¤ì¤ë¥Ð¥° 3646 2001-05-21 20:45 ¨±["MINOHATA Norio" <mi] 3650 2001-05-22 15:21 ¡¡¨²[Akihiko Shinohara <s] 3652 2001-05-22 17:55 ¡¡¨¨±["MINOHATA Norio" <mi] 3654 2001-05-23 03:11 ¡¡¨±[tateyan <tateyan@xxx] 3658 2001-05-23 11:10 ¡¡¡¡¨±[Yasuhide OMORI / Âç¿]