Cytat
LOAD DATA LOCAL INFILE "'.realpath(dirname(__FILE__).'/../../'.$sciezka_csv).'"
INTO TABLE `'.$baza_danych.'`
CHARACTER SET utf8
FIELDS TERMINATED BY "'.$delimiter.'"
OPTIONALLY ENCLOSED BY "\""
LINES TERMINATED BY "\n"
IGNORE 1 LINES
INTO TABLE `'.$baza_danych.'`
CHARACTER SET utf8
FIELDS TERMINATED BY "'.$delimiter.'"
OPTIONALLY ENCLOSED BY "\""
LINES TERMINATED BY "\n"
IGNORE 1 LINES
Probowalem wiec dodac na samym koncu to:
Cytat
(`product ID`, `name`, `currency`, `price`, `description`, `productURL`, `imageURL`, `categories`, `product_id`)
ale dodaje z paru tysiecy linijek, tylko 4 i to w zlej kolejnosci. Oczywiscie pola te wystepuja i w bazie i w csv, pytanie co zle robie ?