http://www.mysql.com/documentation/mysql/commented/manual.php?section=LOAD_D
ATA
LOAD DATA LOCAL INFILE "myfile.txt" INTO TABLE mytable FIELDS TERMINATED BY
'|'
----- Original Message -----
From: "Marcus Ouimet" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 1:47 PM
Subject: Loading Data :-)
> I am still very new to MySQL, I am trying to convert a flat line database
to
> MySQL (Database uses | as a deliminator). I have found what I need in the
> documentation to do this yet I am a bit stuck. Could someone be so kind to
> give me an example of (mysql> LOAD DATA LOCAL INFILE "myfile.txt" INTO
> TABLE mytable;) with | instead of a tab deliminator. My database looks
> similiar to:
>
> field1|field2|field3
> field1|field2|field3
> field1|field2|field3
> field1|field2|field3
>
> etc..
>
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail [EMAIL PROTECTED]
>
> To unsubscribe, send a message to:
> <[EMAIL PROTECTED]>
>
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
>
>
>
--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a message to:
<[EMAIL PROTECTED]>
If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
http://lists.mysql.com/php/unsubscribe.php
