Sebastian wrote:
the example i just showed you doesn't need to use delimited syntax. it
will load the entire contents of the file into the column you specify..
try it a test:
CREATE TABLE `table_test` (
`content` mediumtext NOT NULL
) ENGINE=MyISAM;
Mediumtext can be too much, depending on
the example i just showed you doesn't need to use delimited syntax. it
will load the entire contents of the file into the column you specify..
try it a test:
CREATE TABLE `table_test` (
`content` mediumtext NOT NULL
) ENGINE=MyISAM;
create a txt file 'data.txt' with some text, then run query:
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...)
Gr
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
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (sup
