List:General Discussion« Previous MessageNext Message »
From:memo garcia Date:June 1 2010 2:24pm
Subject:load data in php
View as plain text  
Hi all,

 

I have the following script:

Load data

Local infile ‘myData.csv’

Into table myTable

Fields terminated by ‘,’

Enclosed by ‘’

Lines terminated by ‘\r\n’

(field1, field2, …)

 

When this is sourced directly from mysql it works fine, but when invoked
from php, I get the error

The used command is no allowed with this MySQL version

 

Any help on this?

 

Thanks,

 

Memo García Sir

CIS Asociados Consultores en Transporte S.A.

Austria 2042 Providencia

Santiago de Chile

F: 56-2- 2051033  Fax: 56-2-2051029

www.cisconsultores.cl 

 


Thread
load data in phpmemo garcia1 Jun
  • Re: load data in phpMike1 Jun
    • RE: load data in phpmemo garcia1 Jun
      • Re: load data in phpMichael Dykman1 Jun