>> LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);
Syntax isn't quite correct with field and line terminators specified.
>>
>> You must also specify a column list if the order of the fields in the
input
>> file differs from the order of the columns in the table. Otherwise
>Am Dienstag, 16. Mai 2006 17:40 schrieb [EMAIL PROTECTED]:
>> I'm trying to use the load data infile syntax within a php script. The
data
>> is in csv format. I was under the impression that I could reorder the
>> fields during the insert, such as:
>> "load data infile 'currentData.txt' into tabl
Am Dienstag, 16. Mai 2006 17:40 schrieb [EMAIL PROTECTED]:
> Greets,
>
> I'm trying to use the load data infile syntax within a php script. The data
> is in csv format. I was under the impression that I could reorder the
> fields during the insert, such as:
> "load data infile 'currentData.txt' int
Greets,
I'm trying to use the load data infile syntax within a php script. The data
is in csv format. I was under the impression that I could reorder the
fields during the insert, such as:
"load data infile 'currentData.txt' into table(fieldName2, fieldName1)
fields terminated by ','"; The stuff
2 things:
> mysql_query($QueryInsert);
> print mysql_error();
Should read:
$query = mysql_query($QueryInsert) or die(mysql_error());
and:
>> It returns "Can't get stat of '/www/publico2/tableData0TMRRy' (Errcode: 13)".
what exactly is: "tableData0TMRRy"?? if it should be a file, it should
I have this code:
It returns "Can't get stat of '/www/publico2/tableData0TMRRy' (Errcode:
13)".
I'd put this file into mySQL's database dir, but I have no access there.
Any ideas how to do this? Inserting file row by row would take like
eternity, so that is not a good idea.
Niklas