<div>
Check whether the user has File Privilege access or not.<br />
<br />
<a href="https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_file" rel="ugc">https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_file</a><br />
<br />
Query looks fine . This column ( PAT_REM ) has datatype - TEXT / BLOB? correct.
</div>


<div>
Please see if this works..<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42380211-1"><span>CREATE TABLE testr</span>
<span>(</span>
<span>ID	INTEGER AUTO_INCREMENT,</span>
<span>Fr	TEXT, </span>
<span>PRIMARY KEY (ID)</span>
<span>);</span>
<span></span>
<span>INSERT INTO testr(ID, Fr) VALUES (1, LOAD_FILE('D:/TMP/PAT_MEMO.txt'));</span>
</code></pre>
</div>


<div>
Also try moving the file to c drive.
</div>


<div>
Pawan Kumar, <br />
Yes it works but in my case my patient table is already populated... so i do not need to create another register,<br />
is there anyway to do the same with update ?
</div>


<div>
oh you mean I work in a paralel table and transfer after uploading ?<br />
got you .. testing<br />
<br />
But is there anyway to do it without using a paralel temporal table ?<br />
Regards
</div>


<div>
Edited my last comment. Please refresh the page and check my last comment.<br />
-&gt;&gt;<b>LOAD FILE loads an entire table, not one column, not one cell</b>.
</div>


<div>
@RGuillermo - Is my comment assisted ?? I gave your all the details with working code., David just repeated what i said earlier ? Split -equal ??
</div>


<div>
Pawan Kumar, <br />
After several tests I find David Favor's suggestion much more in control and useful than yours. Your´s worked only on specific cases and did not fill my expectations.....<br />
<br />
this is my evaluation, I appreciate the effort all experts do but I do not consider appropiate or polite to question a somebody´s personal evaluation and point of view according to your personal standards.<br />
<br />
if you disagree with my personal evaluation maybe you should contact experts-exchange to reconsider the system<br />
<br />
In ten years using Experts- Exchange, I have never seen this kind of reaction, <br />
I hope the high level and profesionalism of this site remains the same.<br />
<br />
I hope a moderator reads this post.
</div>


<div>
&gt;&gt;After several tests I find David Favor's suggestion much more in control and useful than yours.<br />
That's all right.. Apologies didn't want to offend you. Its just that the closing comments did not have much details so just asking to my knowledge for forward :)<br />
<br />
Cheers !!
</div>


<div>
<div class="content wysiwyg-content">
Hello experts,<br />
I need to store in trext fields some text files no bigger than a 100 k<br />
<br />
using the following<br />
UPDATE TBL_PATIENTS SET PAT_REM = LOAD_FILE('D:/TMP/PAT_MEMO<wbr />.TXT') WHERE PAT_COD = 2;<br />
it retuns ok but no change in the field... remains empty.<br />
<br />
What am I doing wrong, is there a better way ?<br />
Regards,
</div>
</div>


Hello experts,
I need to store in trext fields some text files no bigger than a 100 k

using the following
UPDATE TBL_PATIENTS SET PAT_REM = LOAD_FILE('D:/TMP/PAT_MEMO.TXT') WHERE PAT_COD = 2;
it retuns ok but no change in the field... remains empty.

What am I doing wrong, is there a better way ?
Regards,

MYSQL uploading text files to text fields

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.