mysql:12123
From: "safe" <"safe" <geohase@xxxxxxxxxx>>
Date: Fri, 9 Sep 2005 11:29:19 +0900
Subject: [mysql 12123] Re: ¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ø¤Î½ÐÎϤηï
¿ù¼ÍÍ ¤´»ØƳ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£ £È£Å£Ì£Ð¤â¸«¤Æ¡¢tee¤â¸«¤Æ¡¢outfile¤È¤¢¤ë¤Î¤Ç¡¢¤³¤ì¤Ç½Ð¤»¤ë¤Î¤«¤Ê ¤È¤Ï»×¤Ã¤Æ¤¤¤¿¤Î¤Ç¤¹¤¬¡¢»È¤¤Êý¤¬Ê¬¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£ ÍÌ°æÍͤϤ³¤ì¤ò¥Ò¥ó¥È¤Ç¡¢Ä¾ÀܤΥե¡¥¤¥ëºîÀ®¤ÈÍý²ò¤µ¤ì¤¿¤È¤Î¤³¤È ¤Ç¤¹¤¬¡¢¾®À¸¤Ï̤¤À¤Ë¾å¼ê¤¯½ÐÍè¤Þ¤»¤ó¡£¡¡¥Á¥å¡¼¥È¥ê¥¢¥ë¤Ç»ÈÍÑÎã ¤òõ¤·¤¿¤ê¤â¤¹¤ë¤Î¤Ç¤¹¤¬¡¢º£¤Î½ê¸«Åö¤¿¤é¤º¡¢tee°¿¤¤¤Ï\T¤ò¤É¤Î ¤è¤¦¤Ë¥³¥Þ¥ó¥É¤È¤·¤Æ»È¤¦¤Î¤«¤¬Íý²ò½ÐÍè¤Æ¤¤¤Þ¤»¤ó¡£¡¡¤´»ØƳ夤 ¤¿¤Î¤Ë¥ì¥Ù¥ë¤¬Ä㤯¤ÆºÑ¤ß¤Þ¤»¤ó¡¢º£¸å¹¹¤ËÊÙ¶¯¤·¤Þ¤¹¡£ ¼è¤ê´º¤¨¤º¤ÏḬ́椵¤ó¤Ë¤´¶µ¼¨Äº¤¤¤¿ÊýË¡¤Ç¡¢¥·¥§¥ë¤«¤é²¼µ¤Ç ¥Æ¡¼¥Ö¥ë¥ê¥¹¥È¤ò½ñ¤½Ð¤»¤Þ¤·¤¿¤Î¤Ç¡¢¤³¤ì¤Ç´Ö¤Ë¹ç¤ï¤»¤Þ¤¹¡¨ C>mysql -u root -p dbase>C:\aaa.txt EnterPassword: xxxxxx Show Tables; (aaa.txt¤ËÆâÍƤ¬½ñ¤½Ð¤µ¤ì¤ë¤è¤¦¤Ç¤¹¡Ë \q ¼è¤êµÞ¤®¸æÎé¡¢¤ªÏͤӤȤ´Êó¹ð¤Þ¤Ç¡£¡¡¡¡¡¡¡¡¡¡GEOHASE Subject: [mysql 12115] Re: ¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ø¤Î½ÐÎϤηï ******************************************************* > ¿ù¼¤Ç¤¹¡£ > >> ¥·¥§¥ë¥×¥í¥ó¥×¥È¤«¤éMySQL¤ËÆþ¤Ã¤Æ¡ÊMySQL¤Î >> ¥×¥í¥ó¥×¥È) use test; show tables; ¤Ç¥Æ¡¼¥Ö¥ë¤Î°ìÍ÷ >> ¤¬½Ð¤ë¤Î¤Ç¤¹¤¬¡¢¤³¤ì¤ò¥Õ¥¡¥¤¥ë¤ËÍî¤È¤¹¤³¤È¤¬½ÐÍè¤Æ >> ¤¤¤Þ¤»¤ó¡£¡¡MySQL¤Î¥×¥í¥ó¥×¥È¤Ç mysql -u root -p< >> test.sql¡¡¤Ï1064¤ÎSyntax¥¨¥é¡¼¤È¤Ê¤ê¤Þ¤¹¡£ > > ¥Ø¥ë¥×¤ò¸«¤Ê¤¤¤Î¤ÏÌÌÅݤÀ¤«¤é¤Ç¤¹¤«? > ¤â¤¦¤Á¤ç¤Ã¤ÈÅØÎϤ·¤Æ¤ß¤Æ¤â¤¤¤¤¤ó¤¸¤ã¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£ > > ¢¤³¤ó¤Ê¤Î¤¬»È¤¨¤½¤¦¤Ç¤¹¤è¤Í¡£ > > tee (\T) Set outfile [to_outfile]. Append everything into given > outfile. > ¿ù¼ µ®»Î <sugimura@xxxxxxxxxx> > GnuPG fingerprint: C81B 9835 1C9E BD9B 84BF 9785 0B91 D08B F667 DCED >
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]