what you mean by "whole txt" the entire contents of the file or the
actual file itself?
to load the contents in it:
LOAD DATA INFILE '/path/to/data.txt' INTO TABLE tb1 (col1,col2,...);
otherwise the column has to be blob type, using normal insert query:
INSERT INTO table VALUES (data...)
Gregory Machin wrote:
Hi all
How does one save a whole txt file in a largetext column ?
Ihave found l lots on delimited filesbut non on saving a whole text file .
Many thanks
--
Certified E-mail - No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.336 / Virus Database: 267.9.2/54 - Release Date: 7/21/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
