Dear all, I had a problem with load data infile syntax LOAD DATA INFILE '$file' REPLACE INTO TABLE $table FIELDS TERMINATED BY '|' that the original data has already carriage returns was considered as new records in the database, I solved it by using the following syntax: LOAD DATA INFILE '$file' REPLACE INTO TABLE $table FIELDS TERMINATED BY '|' LINES TERMINATED BY '^' well it worked BUT it generates a strange blank charachter at the beginning of the first field of each record is there any soloution that brings me peace of mind for such problems, concerning that I previously suffered from developing in local environment before publishing which forced me to use two different syntaxes of LOAD DATA... the first one with ADDSLASHES() function to the $file argument and the second without this funcion Please advice if you a solution
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
