[PHP-DB] Upload csv file into mysql

2002-09-03 Thread Dr. Indera 

Hello,

Is there a way to upload data in a csv file into a mysql table?

Thanks
Indera



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Upload csv file into mysql

2002-09-03 Thread Beau Lebens 

try phpMyAdmin - nice and easy, although i'm pretty sure there is a direct
command line.


// -Original Message-
// From: Dr. Indera [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 4 September 2002 12:21 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Upload csv file into mysql
// 
// 
// Hello,
// 
// Is there a way to upload data in a csv file into a mysql table?
// 
// Thanks
// Indera
// 
// 
// 
// -- 
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
// 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Upload csv file into mysql

2002-09-04 Thread rhelms 

Hi Dr. Indera, 

> 
> Is there a way to upload data in a csv file into a mysql table?

Try phpMyadmin.

Regards,
Ruprecht

---
Ruprecht Helms  -   IT-Service und Softwareentwicklung

Homepage: http://www.rheyn.de
email: [EMAIL PROTECTED]
=
E-Mail: Ruprecht Helms <[EMAIL PROTECTED]
Date: 04-Sep-02
Time: 10:10:56

This message was sent by XFMail
---

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Upload csv file into mysql

2002-09-04 Thread Ignatius Reilly 

Hi Dr,

try:

LOAD DATA INFILE "myfile.csv" INTO TABLE mytable
FIELDS TERMINATED BY ","
LINES TERMINATED BY "\r\n" ;

of course, the structure of your CSV file must match exactly that of your
table.

hth

- Original Message -
From: "Dr. Indera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 6:20 AM
Subject: [PHP-DB] Upload csv file into mysql


> Hello,
>
> Is there a way to upload data in a csv file into a mysql table?
>
> Thanks
> Indera
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Upload csv file into mysql

2002-09-04 Thread Karel 

Hi this was very helpful to me, just now trying that

what if i have TABLE (id_item, rate1, rate2, rate3, rate4)

and

CSV file like foll

id_item,rate1,rate2
1,250,260
2,270,280
5,290,290

and what exactly mean \r in a TERMINATED BY?

thx kaja



S prátelským pozdravem
Karel Príbramský
AbiaNet, s.r.o.-www.abianet.cz---


-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 9:51 AM
To: [EMAIL PROTECTED]; Dr. Indera
Subject: Re: [PHP-DB] Upload csv file into mysql


Hi Dr,

try:

LOAD DATA INFILE "myfile.csv" INTO TABLE mytable
FIELDS TERMINATED BY ","
LINES TERMINATED BY "\r\n" ;

of course, the structure of your CSV file must match exactly that of your
table.

hth

- Original Message -
From: "Dr. Indera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 6:20 AM
Subject: [PHP-DB] Upload csv file into mysql


> Hello,
>
> Is there a way to upload data in a csv file into a mysql table?
>
> Thanks
> Indera
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Upload csv file into mysql

2002-09-04 Thread Ignatius Reilly 

You have to create your CSV by escaping the real data commas (eg
"1\,250\,260") when creating your CSV file - \ usually works, but you can
choose sth else if you have "\" actual data characters (usually not
recommended!).

and add
ESCAPED BY "\" to your LOAD statement

HTH

Ignatius

- Original Message -
From: "Karel Pøíbramský" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
"Dr. Indera" <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 10:33 AM
Subject: RE: [PHP-DB] Upload csv file into mysql


> Hi this is very helpful to me
>
> what if i have TABLE (id_item, rate1, rate2, rate3, rate4)
>
> and
>
> CSV file like foll
>
> id_item,rate1,rate2
> 1,250,260
> 2,270,280
> 5,290,290
>
> ?
>
> thx kaja
>
>
>
> S prátelským pozdravem
> Karel Príbramský
> AbiaNet, s.r.o.-www.abianet.cz---
>
>
> -Original Message-----
> From: Ignatius Reilly [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 04, 2002 9:51 AM
> To: [EMAIL PROTECTED]; Dr. Indera
> Subject: Re: [PHP-DB] Upload csv file into mysql
>
>
> Hi Dr,
>
> try:
>
> LOAD DATA INFILE "myfile.csv" INTO TABLE mytable
> FIELDS TERMINATED BY ","
> LINES TERMINATED BY "\r\n" ;
>
> of course, the structure of your CSV file must match exactly that of your
> table.
>
> hth
>
> - Original Message -
> From: "Dr. Indera" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 04, 2002 6:20 AM
> Subject: [PHP-DB] Upload csv file into mysql
>
>
> > Hello,
> >
> > Is there a way to upload data in a csv file into a mysql table?
> >
> > Thanks
> > Indera
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php