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

mysql:11163

From: "kondo kondo" <"kondo kondo" <umiushi_00@xxxxxxxxxx>>
Date: Tue, 15 Mar 2005 07:14:17 +0000
Subject: [mysql 11163] Re: MYSQL¤ò»È¤Ã¤¿¥Ð¥¤¥Ê¥ê¥Õ¥¡¥¤¥ë¥¤¥ó¥µ¡¼¥È

¶áÆ£¤Ç¤¹¡£
>¤ªÀ¤ÏäˤʤäƤª¤ê¤Þ¤¹¡£²Ï¹ç¤È¿½¤·¤Þ¤¹¡£
>´Êñ¤Ê¼ÁÌ䤫¤âÃΤì¤Þ¤»¤ó¤¬¡¦¡¦¡¦¡¦¡£
>
>¥Ð¥¤¥Ê¥ê¥Õ¥¡¥¤¥ë¤ò¥Æ¡¼¥Ö¥ë¤ËÊݸ¤·¤¿¤¤¤È¤­¡¢
>
>INSERT INTO tbl_thesis values 
('00000000000000000002','vvvvvv','','5','vvvvvv','','','','','','','','','','2004-4-01','','','','','','','','','','','fdfdssfdg','dvgdsgsd','1','20050315 
15:15:04','',load_file('C:\a.pdf'))
>
>¢¬¾åµ­¤Î¤è¤¦¤ÊInsertʸ¤ò½ñ¤­¡¢pdf¥Õ¥¡¥¤¥ë¤ÎÊݸ¤¹¤ë¥Æ¡¼¥Ö¥ëÎó¤Ïlongblob
>¤È¤·¤¿¤Î¤Ç¤¹¤¬¡¢
>
>Can't get stat of 'C:a.pdf' (Errcode: 2)
>

Can't get stat of 'C:a.pdf'¤Ã¤Æ¡¢"C:\"¤¬"C:"¤Ë¤Ê¤Ã¤Æ
¤Þ¤¹¤è¤Í¡£¤Ò¤ç¤Ã¤È¤·¤Æ\¤¬¥¨¥¹¥±¡¼¥×¤µ¤ì¤Æ¤Þ¤»¤ó¤«¡©
¤À¤È¤¹¤ë¤È¡¢°Ê²¼¤Îʸ¤Ï¤¤¤«¤¬¤Ç¤·¤ç¤¦¤«¡©

INSERT INTO tbl_thesis values 
('00000000000000000002','vvvvvv','','5','vvvvvv','','','','','','','','','','2004-4-01','','','','','','','','','','','fdfdssfdg','dvgdsgsd','1','20050315 
15:15:04','',load_file('C:\\a.pdf'))

MySQL¤Î¥Ø¥ë¥×¤Ç¤Îload_file()¤ÎÀâÌÀ¤¬¤¢¤Ã¤¿¤Î¤Ç¡¢
°Ê²¼¤Ëžµ­¤·¤Þ¤¹¡£
¡Ê¥Ø¥ë¥×¤Îžµ­¤Ã¤ÆOK¤Ç¤·¤¿¤Ã¤±¡©¥À¥á¤Ê¤é¤´»ØŦ¤ò¡¦¡¦¡¦¡Ë
"¡Ê¥À¥Ö¥ë¥¯¥©¡¼¥È¡Ë¤È'¡Ê¥·¥ó¥°¥ë¥¯¥©¡¼¥È¡Ë¤¬°ã¤¦¤«¤é¡¦¡¦¡¦¤È¤«
¤Ê¤¤¤Ç¤¹¤è¤Í¡©¡©^^;

¢£MySQL¥Ø¥ë¥×¤è¤ê

LOAD_FILE(file_name)
    ¥Õ¥¡¥¤¥ë¤òÆɤ߼è¤ê¡¢¥Õ¥¡¥¤¥ë¤ÎÆâÍƤòʸ»úÎó¤È¤·¤ÆÊÖ¤¹¡£
¥Õ¥¡¥¤¥ë¤Ï¥µ¡¼¥Ð¾å¤Ë¸ºß¤·¤Ê¤±¤ì¤Ð¤Ê¤é¤º¡¢¥Õ¥¡¥¤¥ë¤Î¥Õ¥ë
¥Ñ¥¹Ì¾¤ò»ØÄꤹ¤ëɬÍפ¬¤¢¤ë¡£¤Þ¤¿¡¢FILE ¸¢¸Â¤¬É¬ÍפȤʤ롣
¥Õ¥¡¥¤¥ë¤ÏÁ´¥æ¡¼¥¶¤¬Æɤ߼è¤ê²Äǽ¤Ç¤Ê¤±¤ì¤Ð¤Ê¤é¤º¡¢
max_allowed_packet ¤è¤ê¾®¤µ¤¤¥µ¥¤¥º¤Ç¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¡£
 ¥Õ¥¡¥¤¥ë¤¬Â¸ºß¤·¤Ê¤¤¾ì¹ç¤ä¡¢¾åµ­¤ÎÍýͳ¤Î¤¤¤º¤ì¤«¤Ë
¤è¤Ã¤ÆÆɤ߼è¤êÉÔ²Äǽ¤Ê¾ì¹ç¡¢¤³¤Î´Ø¿ô¤Ï NULL ¤òÊÖ¤¹¡£

mysql> UPDATE tbl_name
           SET blob_column=LOAD_FILE("/tmp/picture")
           WHERE id=1;

_________________________________________________________________
̵ÎÁ250MB¥á¡¼¥ë¥Ü¥Ã¥¯¥¹¤ÎMSN Hotmail 
https://registernet.passport.net/reg.srf?id=2&lc=1041 


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

     11162 2005-03-15 15:56 [Toshinori Kawai <kaw] MYSQL¤ò»È¤Ã¤¿¥Ð¥¤¥Ê¥ê¥Õ¥¡¥¤¥ë¥¤¥ó¥µ¡¼¥È 
->   11163 2005-03-15 16:14 ¨±["kondo kondo" <umius]                                       
     11164 2005-03-15 16:39 ¡¡¨±[Toshinori Kawai <kaw]                                     
     11165 2005-03-15 16:56 ¡¡¡¡¨±["kondo kondo" <umius]                                   
     11166 2005-03-15 17:12 ¡¡¡¡¡¡¨±[Toshinori Kawai <kaw]                                 
     11167 2005-03-15 17:37 ¡¡¡¡¡¡¡¡¨²["kondo kondo" <umius]                               
     11168 2005-03-15 18:00 ¡¡¡¡¡¡¡¡¨­¨²[Toshinori Kawai <kaw]                             
     11169 2005-03-15 18:30 ¡¡¡¡¡¡¡¡¨­¨­¨±[Ryuji Matsushita <ma]                           
     11170 2005-03-15 18:37 ¡¡¡¡¡¡¡¡¨­¨­¡¡¨±[Toshinori Kawai <kaw]                         
     11171 2005-03-15 19:47 ¡¡¡¡¡¡¡¡¨­¨­¡¡¡¡¨±[Ryuji Matsushita <ma]                       
     11173 2005-03-15 20:46 ¡¡¡¡¡¡¡¡¨­¨­¡¡¡¡¡¡¨±[Tetsuro IKEDA <ikdtt]                     
     11172 2005-03-15 20:34 ¡¡¡¡¡¡¡¡¨­¨²[SUGIMURA Takashi ¿ùÂ]                             
     11174 2005-03-15 21:47 ¡¡¡¡¡¡¡¡¨­¨±[Sumito_Oda <oda@xxxx]                             
     11175 2005-03-15 23:04 ¡¡¡¡¡¡¡¡¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                               
     11177 2005-03-16 10:13 ¡¡¡¡¡¡¡¡¡¡¨±[Toshinori Kawai <kaw]