I developed a PHP application where users can update a mySQL table using
LOAD DATA. Recently I installed this application on another web server where
the File Permissions have been set such that this method of uploading data
is no longer valid. Since phpMyAdmin is not an option I am trying to find
#x27;
or
"LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY ','
LINES TERMINATED BY '\\r\\n'
I dont know however the proper syntax to include both field termination
parameters in one LOAD statement like I am able to
ALUES (100,1,2,3,4,5,6,7,8,9,'')
zero (0) gets inserted in the Icon field.
It appears DEFAULT doesn't work.
Thanks,
Chris Williams
-
Before posting, please check:
http://www.mysql.com/manual.php
