Import File To Table

alirezaok

hello

i have 2 text files with names: fname.txt lname.txt
i have a table with 2 fields: fname lname

i want import text files to my table
but when i use these commands for import:

$sql = 'LOAD DATA INFILE \'C:\\\\fname.txt\' INTO TABLE `118` FIELDS TERMINATED BY \'\' ESCAPED BY \'\\\\\' LINES TERMINATED BY \'\\r\\n\'( `fname` )'; 

$sql = 'LOAD DATA INFILE \'C:\\\\lname.txt\' INTO TABLE `118` FIELDS TERMINATED BY \'\' ESCAPED BY \'\\\\\' LINES TERMINATED BY \'\\r\\n\'( `lname` )';

result of table is:

fname lname
jim Null
bil Null
tim Null
Null benson
Null hevenal
Null melody

but i want this result of table:

fname lname
jim benson
bil hevenal
tim melody

what is the second $sql to this result that i want?

Thanks

bubblenut

Can you put the above code into [code] tags rather than [php] tags please, PHPBB's messing with the output.
Thanks
Bubble

alirezaok

i puted with

bubblenut

How is your file structured? You have said FIELDS TERMINATED BY '' which doesn't really make sense, each field in the must be terminated by a specified character and this must be told to MySQL. So if you're file looks like this (comma terminated fields)

jim, benson
bil, hevenal
tim, melody

you would use the command

LOAD DATA INFILE 'C:\\fname.txt' INTO TABLE `118` FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\n'( `fname` )

to load the file and you would get

Field one Field two
jim benson
bil havenal
tim melody

in the table
HTH
Bubble

alirezaok

I used from phpmyadmin.
my problem is not " or '
i can load text files
but i have 2 text files
i can not merge 2 text files to 1 text file

bubblenut

Ahh, sorry, my mistake. I misunderstood.
In order to achieve this you're going to have to write a script. The basic procedures will be as follows. Assuming the files are relative small.

$sql_start="INSERT INTO table (column1, column2) VALUES";
$file1=file('/path/to/file1');
$file1_c=count($file1);
$file2=file('/path/to/file2');
$file2_c=count($file2);
if($file1_c!=$file2_c) exit('Row count mismatch');
$sql=$sql_start;
for($i=0, $j=0;$i<$file1_c;$i++, j++) {
  $sql.=($j!=0?',':'')."('".$file1[$i]."','".$file2[$i]."')";
  if($j<50) {
    mysql_query($sql);
    $sql=$sql_start;
  }
}

It could do with a little more error checking in there but you get the idea.
HTH
Bubble

alirezaok

thank you from ur idea. i try it