look at the manual, section :
6.4.9 LOAD DATA INFILE Syntax
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]
I've never done it, but you can load a file into a single field/column.
-----Original Message-----
From: chiou%2dguey liaw [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:48 PM
To: [EMAIL PROTECTED]
Subject: BLOB in mysql
Hi,
I am trying to store a .gz file in a BLOB field in a mysql database. I have
tried two commands :
1. Insert into mytable values('1', 'file1.gz');
2 Insert into mytable values('1,','\'file1.gz\'');
These two commands just store the name of the file in the BLOB field instead
of
the content of the file. How should I do my Insert statement in mysql?
Thanks.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
