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

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 / Âç¿]