https://performiq.com/kb/index.php?action=history&feed=atom&title=MySQL_Data_Loading 2026-05-18T23:08:20Z Revision history for this page on the wiki MediaWiki 1.37.1 https://performiq.com/kb/index.php?title=MySQL_Data_Loading&diff=3639&oldid=prev 2011-10-01T13:04:46Z

<p>Created page with &#039;=Inserting large amounts of data into MySQL with LOAD DATA INFILE= Use this on the command line withing the MySQL client to build load data: load data infile &#039;customers.csv&#039; i...&#039;</p> <p><b>New page</b></p><div>=Inserting large amounts of data into MySQL with LOAD DATA INFILE=<br /> <br /> Use this on the command line withing the MySQL client to build load data:<br /> <br /> load data infile &#039;customers.csv&#039; into table site.customer<br /> fields terminated by &#039;,&#039; enclosed by &#039;&quot;&#039; lines terminated by &#039;\n&#039;<br /> (email,password,title,first_name,last_name);<br /> <br /> The field separator is specified as the default separator is a tab.<br /> <br /> For more info on the command see:<br /> <br /> * http://dev.mysql.com/doc/refman/5.1/en/load-data.html.<br /> <br /> [[Category:MySQL]]</div>

PeterHarding