php mysql load data infile

From: Slavo Fabian <zdarma (zavinac)>
Date: 04. 01. 2004, 11:21 CET
Ake mate skusenosti s automatickym nacitavanim dat zo suborov do mysql 
databazy ?

Skusam rozne varianty skriptu typu

$result = mysql_query ("LOAD DATA LOW_PRIORITY INFILE 
'http://www.domena.sk/cenniky/cennik.csv' INTO TABLE pchry FIELDS 
TERMINATED BY ';'  ")
      or die ("Query failed load");

ale nebezi mi to, ak je ten subor vzdialenej adrese.

Ak dam vlozenie do databazy suboru leziaceho na lokalnom pocitaci, 
vsetko zbehne aj ked je subor na lokale a databaza niekde inde na serveri.


S.Fabian
Received on Sun, 04 Jan 2004 11:21:50 +0100

This archive was generated by hypermail 2.1.8 : 04. 01. 2004, 11:22 CET