I am having error while using load data local infile on button…
–here’s the code
sc_exec_sql(“load data local infile ‘/PATH/IMPORT/FILE’ into table TABLETOIMPORT fields terminated by ’ ’ lines terminated by ’
'”)
this script returns:
Error while accessing the database:
The used command is not allowed with this MySQL version
but it works fine when i execute this same script on mysql on server(Ubuntu server)
load data local infile ‘/PATH/IMPORT/FILE’ into table TABLETOIMPORT fields terminated by ’ ’ lines terminated by ’
’
How to solve this problem??
Thanks!