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
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:
, 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
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
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
//
//
//