MySql statment being truncated in PHP ?

Anon

I build a mysql table with 30 fields, and i am having problems inserting or updating, be cause the mysql parser says show that the command had a sintex error. I depure the php script and see that de variable that have the sql statment is ok, but sql receive the command truncated. This limitation is from MySql, Windows (98) or from server (i am using the Jana Server at this moment).

Thanks - Sidney

Anon

please do type your command..

nilesh.

Anon

One of the commands with problems is this one.

$sql="load data local infile 'd:\www\proc1.txt' ".
"into table Processos ".
"fields terminated by ';' ".
"OPTIONALLY ENCLOSED BY '\"' ".
"ESCAPED BY '\' ".
"LINES TERMINATED BY '\n' ".
"(".
"numero, situacaoprocesso, fase, cliente, campo6, carteira, ".
"contrato, agencia, contacorrente, cgcreu, nomereu, enderecoreu, ".
"cepreu, nomeavalista, cgcavalista, nomeavalista2, cgcavalista2, ".
"datacausa, malote, datamalote, numeroprocesso, datasituacaoprocesso, ".
"campo1, numeromestre, honorario, campo2, campo3, campo4, campo5, telefonereu".
")";

When executed, mysql return to php the following error :
Error : You have an error in your SQL syntax near '\n' (numero, situacaoprocesso, fase, cliente, campo6, carteira, contrato, agenci' at line 1
Dont be possible to update the espcified information.

Sidney.

Anon

what i would suggest doing is using the regular mysql client ( c:\mysql\bin\mysql ) to issue the queries instead of doing it on the web via php. this ofcourse is possible only if you are kind of initializing the database and dont want it as a repititive task (maybe for users of ur website).

if only you are the person doing these kind of queries then do use the mysql client. you can specify a file to the mysql client as an input.

mysql -u username -p databasename < filename

or in otherwords

c:\mysql\bin\mysql -u username -p databasename < d:\www\proc1.txt

for windows i dont think you need the "-u username -p" in the command. try it.

your proc1.txt would then contain SQL commands to be issued against "databasename" in the command line.

eg. contents of proc1.txt

proc1.txt

insert into table(field1,field2) values('valueA','valueB');
insert into table(field1,field2) values('valueC','valueD');
insert into table(field1,field2) values('valueE','valueF');

end proc1.txt

well, you can modify the proc1.txt with any queries, etc.

cheers. nilesh