Never did it but try this. After uploading the csv file to the server use mysql to do the rest
LOAD DATA *LOCAL* INFILE '*/importfile.csv*' INTO TABLE *test_table* FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3); See also http://dev.mysql.com/doc/refman/5.1/en/load-data.html On Tue, Apr 6, 2010 at 8:09 AM, Seiya Sekata <[email protected]> wrote: > Dear all > Ho to insert csv file into mysql table? > thank u > > Check out the new CakePHP Questions site http://cakeqs.org and help > others with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using "remove me" as the subject.
