Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By bhuvenesh18 on
Hi ,
I am using Data Load Infile to load content of .txt file to my table ,my query is like this ,
'LOAD DATA INFILE "' . $filepath . '" ignore INTO TABLE mytablename FIELDS
TERMINATED BY "," ENCLOSED BY \'"\' LINES TERMINATED BY "\r" IGNORE 1 LINES'
This query working in my Local windows server ,but same in not working in Unix server.
Note: Although in Unix server if I run same query through PHPmyadmin , it gives results perfectly. But it is not working when I am using it in db_query().
Can some one suggest , what thing m I missing in above query.
Thanks
Bhuvenesh