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]