<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent posts to CSV upload to MySQL Database</title><link href="https://forge.codesys.com/forge/talk/Engineering/thread/36179a6500/" rel="alternate"/><link href="https://forge.codesys.com/forge/talk/Engineering/thread/36179a6500/feed.atom" rel="self"/><id>https://forge.codesys.com/forge/talk/Engineering/thread/36179a6500/</id><updated>2021-06-22T19:40:42.910000Z</updated><subtitle>Recent posts to CSV upload to MySQL Database</subtitle><entry><title>CSV upload to MySQL Database</title><link href="https://forge.codesys.com/forge/talk/Engineering/thread/36179a6500/?limit=25#32a6" rel="alternate"/><published>2021-06-22T19:40:42.910000Z</published><updated>2021-06-22T19:40:42.910000Z</updated><author><name>dgirard</name><uri>https://forge.codesys.com/u/dgirard/</uri></author><id>https://forge.codesys.comf0094f0547f55dfd28a96b5c858fce9120ac808c</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Good day&lt;/p&gt;
&lt;p&gt;I am looking for a way to upload a CSV from the PLC to a remote MySQL Database. My first thought is to use the MySQL command 'LOAD DATA LOCAL INFILE 'myfile.csv' INTO TABLE myTable'.&lt;/p&gt;
&lt;p&gt;Has anyone accomplished this before or can recommend a way of doing this?&lt;/p&gt;
&lt;p&gt;Here is a link referencing the command: &lt;a href="https://www.mysqltutorial.org/import-csv-file-mysql-table/#:~:text=The%20LOAD%20DATA%20INFILE%20statement%20allows%20you%20to%20read%20data" rel="nofollow"&gt;https://www.mysqltutorial.org/import-csv-file-mysql-table/#:~:text=The%20LOAD%20DATA%20INFILE%20statement%20allows%20you%20to%20read%20data&lt;/a&gt;,the%20file%20will%20be%20imported&lt;/p&gt;
&lt;p&gt;Thanks in advance&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>