[kwlug-disc] Tools to get data into a mysql database
kb at 2bits.com
Mon Mar 1 22:01:47 EST 2010
Is your data in CSV format, or close to that?
If so, then use the LOAD DATE INFILE
LOAD DATA INFILE 'filename.csv' INTO TABLE *your_table_name*
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
Here are the details on that command:
On Mon, Mar 1, 2010 at 6:29 PM, Insurance Squared Inc. <
gcooke at insurancesquared.com> wrote:
> What kind of tools are available to get a decent sized pile of data into a
> mysql database via keyboard? i.e. I've got tables full of rows and columns
> of data that I have to input via a keyboard and end up as a nice mysql
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
Khalid M. Baheyeldin
Drupal optimization, development, customization and consulting.
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra
Simplicity is the ultimate sophistication. -- Leonardo da Vinci
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the kwlug-disc