Re: Temporary Tables

2003-03-05 Thread Mamatha Balasubramanian
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

Temporary Tables

2003-03-04 Thread Mamatha Balasubramanian
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

Re: Temporary Tables

2003-03-04 Thread Mamatha Balasubramanian
(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

Loading data

2003-02-21 Thread Mamatha Balasubramanian
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

Can't load data using mysqlimport

2003-02-21 Thread Mamatha Balasubramanian
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

Re: Can't load data using mysqlimport

2003-02-21 Thread Mamatha Balasubramanian
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