Hola:
On Tue, Oct 20, 2009 at 08:14:23PM -0400, Jake McGraw wrote:
> Modify your insert statements to take advantage of LOAD DATA INFILE:
Definitely a handy statement. But you'll need to be granted "FILE"
permissions (aka "File_priv") in MySQL, which is not enabled by default.
And the input file needs to be formatted along the lines of a CSV file
rather than as a series of SQL commands.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
_______________________________________________
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/Show-Participation
