Advertisement

02.20.2008 at 09:41AM PST, ID: 23178432
[x]
Attachment Details

load text file into mysql field

Asked by CoreNeter in MySQL, SQL Query Syntax

Tags: Mysql

How do I  dump a text file into a "mediumblob" or "largetext" mysql database field
I've read about LOAD DATA INFILE  but would appreciate help in setting up the command for dumping the entire txt into one specific field.

Thanks


input.txt
---------
This entire file will be dumpted into a specific field
of mysql talbe.
No matter how long.



DB structure
-------------
Database: testingDB
Table: allData
Field: txtDataStart Free Trial
[+][-]02.20.2008 at 09:56AM PST, ID: 20940165

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL, SQL Query Syntax
Tags: Mysql
Sign Up Now!
Solution Provided By: hielo
Participating Experts: 1
Solution Grade: A
 
 
[+][-]02.20.2008 at 12:41PM PST, ID: 20941690

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628