[kwlug-disc] Tools to get data into a mysql database

Khalid Baheyeldin 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

Example:

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:

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

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
> database.
>
> g.
>
>
>
> _______________________________________________
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
>



-- 
Khalid M. Baheyeldin
2bits.com, Inc.
http://2bits.com
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...
URL: <http://astoria.ccjclearline.com/pipermail/kwlug-disc_kwlug.org/attachments/20100301/6ee34613/attachment.html>


More information about the kwlug-disc_kwlug.org mailing list