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]