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

mysql:12111

From: "safe" <"safe" <geohase@xxxxxxxxxx>>
Date: Thu, 8 Sep 2005 15:32:10 +0900
Subject: [mysql 12111] Re: ¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ø¤Î½ÐÎϤηï

ÍȰ椵¤Þ
¤´»ØƳ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¤ªÃѤº¤«¤·¤¤¤Î¤Ç¤¹¤¬¡¢²¼µ­¤Îtest,sql¤Îºî¤êÊý¤¬
ʬ¤«¤Ã¤Æ¤¤¤Þ¤»¤ó¡£
¥·¥§¥ë¥×¥í¥ó¥×¥È¤«¤éMySQL¤ËÆþ¤Ã¤Æ¡ÊMySQL¤Î
¥×¥í¥ó¥×¥È) use test; show tables; ¤Ç¥Æ¡¼¥Ö¥ë¤Î°ìÍ÷
¤¬½Ð¤ë¤Î¤Ç¤¹¤¬¡¢¤³¤ì¤ò¥Õ¥¡¥¤¥ë¤ËÍî¤È¤¹¤³¤È¤¬½ÐÍè¤Æ
¤¤¤Þ¤»¤ó¡£¡¡MySQL¤Î¥×¥í¥ó¥×¥È¤Ç mysql -u root -p<
test.sql¡¡¤Ï1064¤ÎSyntax¥¨¥é¡¼¤È¤Ê¤ê¤Þ¤¹¡£
Window¤Î¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È²èÌ̾å¤Ë½Ð¤ë¥Æ¡¼¥Ö¥ë°ìÍ÷
¤Îɽ¼¨¤ò¥á¥âÄ¢¤Î¥Æ¥­¥¹¥È¥Õ¥¡¥¤¥ë¤ËÊÑ´¹¤·¤¿¤¤¤À¤±¤Ç
¶ìÀ路¤Æ¤¤¤ë¥ì¥Ù¥ë¤Ç¤¹¡£¡¡¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬¡¢¤´»ØƳ
´ê¤¨¤ì¤Ð¤È»×¤Ã¤Æ¤¤¤Þ¤¹¡£¡¡¡¡¡¡¡¡GEOHASE






> ÍÌ°æ¤È¿½¤·¤Þ¤¹¡£
> Mime-Version: 1.0
> Content-Type: text/plain; charset=iso-2022-jp
>
> safe ¤µ¤ó¤Ï½ñ¤­¤Þ¤·¤¿:
>>¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤«¤éÄ̾ï¤Î¥³¥Ô¡¼¤ä¡¢MySQL ¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾>¥Õ¥¡¥¤¥ë̾¤Ç
>>¥×¥í¥ó¥×¥È¤Ë¤Ê¤Ã¤Æ¡¢SQLʸ¤Îshow tables;¤ä¡¢Mysqldump¡¦Mysqlhotcopy
>>Åù¤ò¿§¡¹¤È»î¤¹¤Î¤Ç¤¹¤¬¡¢ËؤÉOutfile¤Ï¥À¥á¤È¤Î¥¨¥é¡¼¤¬½Ð¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
>
> ñ½ã¤Ë°ìÍ÷¤À¤±¤òÆÀ¤é¤ì¤ì¤Ð¤¤¤¤¤Î¤Ç¤¢¤ì¤Ð¥á¥âÄ¢¤ÇSQLʸ¤ò½ñ¤¤¤¿¤â¤Î¤ò
> ºî¤Ã¤Æ¥ê¥À¥¤¥ì¥¯¥È¤ÇÅϤ·¤Æ¤ä¤ì¤Ð¤¤¤¤¤Ç¤·¤ç¤¦¡£
>
> ¤¿¤È¤¨¤Ð¡¢test¤È¤¤¤¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¤¢¤ë¤È¤·¤Þ¤¹¡£
>
> test.sql¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤ò°Ê²¼¤ÎÆâÍƤǺîÀ®¤·¤Þ¤¹¡£
> use test;
> show tables;
>
> ¤³¤ì¤ò
> mysql -u ¥æ¡¼¥¶Ì¾ -p ¥Ñ¥¹¥ï¡¼¥É < test.sql >result.txt
>
> ¤ÇÅϤ·¤Æ¤ä¤ë¤È¥Æ¡¼¥Ö¥ë°ìÍ÷¤¬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]