Re: [PHP] CSV import

2003-07-21 Thread Curt Zirzow
* Thus wrote jwulff ([EMAIL PROTECTED]): > When using something like this: > LOAD DATA LOCAL INFILE '/tmp/phpKBjUWb' INTO TABLE `indoma` FIELDS > TERMINATED BY ',' LINES TERMINATED BY '\r\n' > > How do I also insert a field not in the CSV. For example there are 8 fields > in the CSV and 9 in the

RE: [PHP] CSV import

2003-07-21 Thread Jay Blanchard
[snip] When using something like this: LOAD DATA LOCAL INFILE '/tmp/phpKBjUWb' INTO TABLE `indoma` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' How do I also insert a field not in the CSV. For example there are 8 fields in the CSV and 9 in the table. I want the ninth field to be the name