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

mysql:11173

From: Tetsuro IKEDA <Tetsuro IKEDA <ikdttr@xxxxxxxxxx>>
Date: Tue, 15 Mar 2005 20:46:55 +0900 (JST)
Subject: [mysql 11173] Re: MYSQL ¤ò»È¤Ã¤¿¥Ð¥¤¥Ê¥ê¥Õ¥¡¥¤¥ë¥¤¥ó¥µ¡¼¥È

ÃÓÅĤǤ¹¡£

¤³¤Á¤é¤Ç¤âÆ°ºî³Îǧ¤¬¼è¤ì¤Æ¤¤¤Þ¤¹¡£

OS:Windows2000Pro SP4
MySQL:ver4.0.23 without InstallerÈÇ

-------------------------------------------------
C:\mysql-4.0.23-win\bin>mysqld --print-defaults
mysqld would have been started with the following
arguments:
--basedir=C:\mysql-4.0.23-win
--datadir=C:\mysql-4.0.23-win\data
--default-character-set=ujis --max_allowed_packet=8000000

C:\mysql-4.0.23-win\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version:
4.0.23-nt-max

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

mysql> use test
Database changed
mysql> create table t1 (c1 int primary key, c2 longblob
not null);
Query OK, 0 rows affected (0.12 sec)

mysql> insert into t1 values (1,
load_file('C:\\manual-a4.pdf'));
Query OK, 1 row affected (0.38 sec)

mysql> select c2 into dumpfile 'C:\\copy.pdf' from t1
where c1=1;
Query OK, 1 row affected (0.34 sec)
-------------------------------------------------

copy.pdf¤ò¤Á¤ã¤ó¤È³«¤±¤Æ¡¢ÆâÍƤâmanual-a4.pdf¤ÈƱ¤¸¤Ç¤¹
¡£


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

     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]