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:
, 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&
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]>
S
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 PRO
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
//
//
//
