List:General Discussion« Previous MessageNext Message »
From:memo garcia Date:June 1 2010 3:11pm
Subject:RE: load data in php
View as plain text  
Nike,

 

I’m using

PHP 5.2.3 with Suhosin-Patch 0.9.7 (cli) (built: May 7 2010 08:41:40)

 

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 

  _____  

De: Mike [mailto:hijinks@stripped] 
Enviado el: Tuesday, June 01, 2010 10:34 AM
Para: mgarcia@stripped
CC: mysql@stripped
Asunto: Re: load data in php

 

If you are using v4 of php this will never work

On Tue, Jun 1, 2010 at 10:24 AM, memo garcia <mgarcia@stripped> wrote:

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