Look at LOAD DATA LOCAL INFILE...

load data local infile '//BackLog//import_csv//KCV81_standard_sales.csv'
into table kcv81_standard_sales fields terminated by ','
enclosed by '"'
lines terminated by '\r\n'

----- Original Message -----
From: "Peter Samulat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 25, 2002 8:22 AM
Subject: Data Logging based on MySQL using serial Interface


I'm receiving ASCII Data Records (Microsoft CSV Format; Delimiter = ";")
through the serial interface of a linux-based pc. Now I'm seraching for a
script or program to put this records in a mysql database.

Peter


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to