Thanks!
Mamatha
From: Paul DuBois [EMAIL PROTECTED]
To: Mamatha Balasubramanian
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: Temporary Tables
Date: Tue, 4 Mar 2003 17:31:36 -0600
At 23:19 + 3/4/03, Mamatha Balasubramanian wrote:
Thank you once again.
I have a web-interface
Hi,
I would like to know how MySQL handles multiple temporary tables?
1. Can multiple temporary tables be created at the same time?
2. If so, how does MySQL differentiate them - do we need to explicitly give
them different names inorder to identify them or does MySQL provide a
timestamp (or use
(and thereby using the same program). Can you please
elaborate a little more on this?
Thanks,
Mamatha
From: Paul DuBois [EMAIL PROTECTED]
To: Mamatha Balasubramanian
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: Temporary Tables
Date: Tue, 4 Mar 2003 17:06:30 -0600
At 23:00 + 3/4/03, Mamatha
When I try to use
mysqlimport DatabaseName tablename.txt
from command line, it doesn't work. However, if I use the following command
from mysql prompt
mysqlload data local infile /home//tablename.txt into table
tablename.txt
it works. Can anyone tell me how I can load data from the command
When I tried loading data using the following command from command line:
mysqlimport DatabaseName tablename.txt
I got the following error:
mysqlimport: error : can't get stat of /home/./tablename.txt
However, when I used the following command from mysql prompt, I was able to
load the data
Thanks a lot for your help. It works!
From: Paul DuBois [EMAIL PROTECTED]
To: Mamatha Balasubramanian
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: Can't load data using mysqlimport
Date: Fri, 21 Feb 2003 16:32:31 -0600
At 22:14 + 2/21/03, Mamatha Balasubramanian wrote:
When I tried