can u please show use the content of the test.csv file. Also is "comapny
name" a single column or two different columns
If its two different columns than try this
load data file '/foo/test.csv' into table abc.test fields terminated by ','
(company,name)";
Hi..
I've got an issue with doing a Load data file" cmd..
my test text tbl has a column named "company name" i'm trying to figure out
how to use the load data file cmd, to be able to extract the "company name"
col...
when i do:
load data file '/foo/tes
At 19:58 +0300 3/14/03, [EMAIL PROTECTED] wrote:
I have strange problem with LOAD DATA INFILE
$file="base.txt";
$conn=mysql_connect('localhost', 'user', 'paswd');
mysql_select_db('realestate', $conn);
$query="LOAD DATA INFILE '".$file."' REPLACE INTO TABLE
table_name FIELDS TERMINATED BY '\t' LINE
I have strange problem with LOAD DATA INFILE
$file="base.txt";
$conn=mysql_connect('localhost', 'user', 'paswd');
mysql_select_db('realestate', $conn);
$query="LOAD DATA INFILE '".$file."' REPLACE INTO TABLE
table_name FIELDS TERMINATED BY '\t' LINES TERMINATED
BY '\r\n'";
mysql_query($query,
, one way to do this
is to use SELECT ... INTO OUTFILE into another file and compare this to your
original input file."
> -Original Message-
> From: Calvin Chin [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 28, 2001 9:08 PM
> To: [EMAIL PROTECTED]
> Subject: Help O
Hi list member,
I have a slight problem here. I am testing on the data convertion from
text file into MySQL table.
I am able to use the 'load data infile' command and insert the data into
the table, however, with 1000 warnings. I don't know where I can see the
warning messages ?
Can you peop
