After you log into mysql you can use the following command<div><br><div><i>load data local infile &#39;/path/to/csv/file.csv&#39; into table `mytable` fields terminated by &#39;;&#39; lines terminated by &#39;\n&#39; (field1, field2, field3.....);</i></div>
<div><i><br></i></div><div>The order in which they are organized in the csv should be the same way the fields are organized in the command, also ensure the field headers are not included in the csv file.<br><br><div class="gmail_quote">
On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi<br>Anybody with the above script<br>Regards<br clear="all"><font color="#888888"><br>-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>It is our light, not our darkness, that frightens us.<br>

<br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>
</font><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div></div>