After you log into mysql you can use the following command *load data local infile '/path/to/csv/file.csv' into table `mytable` fields terminated by ';' lines terminated by '\n' (field1, field2, field3.....);* * * 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. On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Anybody with the above script Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke