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

mysql:12067

From: "safe" <"safe" <geohase@xxxxxxxxxx>>
Date: Sat, 3 Sep 2005 15:23:27 +0900
Subject: [mysql 12067] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï

Ω¾¾ÍÍ
¤´»ØƳ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

> C:\> C:\mysql\bin\mysql¤¢¤¿¤ê¤Ë¤¢¤ë¤Ã¤Æ¤³¤È¤Ç¤¹¤Í¡£

MySQL¤Ï¾åµ­¤Î¾ì½ê¤Ë¤¢¤ê¡¢¥Ñ¥¹¤òÄ̤·¤Æ¤¢¤ë¤Î¤Ç¡¢¥³¥Þ¥ó¥É¤Î
¥×¥í¥ó¥×¥È¤Çmysql¤Ç¤¹¤°¤ËÆþ¤ì¤Þ¤¹¡£

> ¤³¤Î¾ì¹çmysqlimport¤Ï»È¤ï¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£
> geohase.sql¤ÏSQLʸ¤òµ­½Ò¤·¤¿¤â¤Î¤Ê¤Î¤Ç¡¢Linux¤Î¾ì¹ç¤À¤È
> shell> /usr/local/mysql/bin/mysql -u YourName -p YourPassword < 
> geohase.sql
> ¤È¤·¤Þ¤¹¡£
> ¤Á¤ç¤Ã¤Èwindows¤Ï»È¤Ã¤¿¤³¤È¤¬Ìµ¤¤¤Î¤Ç¶ñÂÎŪ¤Ê¥³¥Þ¥ó¥É¤¬µ­
> ¤»¤Þ¤»¤ó¤¬
> C:\> C:\mysql\bin\mysql -u YourName -p YourPassword < geohase.sql

¥³¥Þ¥ó¥É¤«¤é¡¢mysql -u root -p ¤Ç¡¡EnterPassword¤È½Ð¤ÆPassword¤òÆþ¤ì¤ë¤È
mysql>¤Î¥×¥í¥ó¥×¥È¤È¤Ê¤ê¤Þ¤¹¡£
¾åµ­¤Îgeohase.sql¤ÎÁ°¤Ï¥µ¡¼¥Ð¤ËÀܳ¤Î¼ê³¤­¤ÈƱ¤¸¤È»×¤¤¤Þ¤¹¤Î¤Ç¡¢Îà¿ä¤Ç
mysql>¤Î¥×¥í¥ó¥×¥È¤Ç¡¢C:\geohase.sql¤È¤¹¤ë¤È¡ÉUnknown Command"¤Î¥¨¥é¡¼¤È
¤Ê¤ê¤Þ¤¹¡£
¤Þ¤¿¡¢mysqlimport¤Ï»È¤ï¤Ê¤¤¤È¤Î¤³¤È¤Ç¤¹¤¬¡¢
mysql>¤Î¥×¥í¥ó¥×¥È¤Ç¡¢mysqlimport geohase C:\geohase.sql¡Ê¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¤¬
geohase¡Ë¤È¤¹¤ë¤È¡¢Syntax¤Î¥¨¥é¡¼¤È¤Ê¤ê¤Þ¤¹¡£

°Ê¾å¡¢¹¹¤Ë¥Ò¥ó¥ÈÅù¤ª´ê¤¤¤Ç¤­¤ì¤Ð¤È»×¤¤¤Þ¤¹¡£¡¡¡¡£Ç£Å£Ï£È£Á£Ó£ÅÇÒ





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

     12055 2005-09-02 18:48 ["safe" <geohase@xxxx] SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï               
     12056 2005-09-02 19:08 ¨±[tatematsu <tatemax@x]                                       
     12057 2005-09-02 19:28 ¡¡¨±[tatematsu <tatemax@x]                                     
     12058 2005-09-02 23:19 ¡¡¡¡¨±["safe" <geohase@xxxx]                                   
     12059 2005-09-03 09:30 ¡¡¡¡¡¡¨±[tatematsu <tatemax@x]                                 
     12061 2005-09-03 11:34 ¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx]                               
     12066 2005-09-03 12:26 ¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x]                             
->   12067 2005-09-03 15:23 ¡¡¡¡¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx]                           
     12068 2005-09-03 16:11 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨²[SUGIMURA Takashi ¿ùÂ]                         
     12069 2005-09-03 16:24 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x]