Re: Technical Clarification

2001-03-19 Thread Fred van Engen
Hi, On Mon, Mar 19, 2001 at 01:23:56AM -0600, Jason Landry wrote: > I know that this response was directly related to a question about > subqueries, but I think it's important to point this out, because I almost > didn't pursue this avenue as a result. > > As Fred pointed out, MySQL does not sup

Re: Technical Clarification

2001-03-18 Thread Jason Landry
> MySQL doesn't support IN and NOT IN. The manual and mailing lists describe > alternatives for many cases, but these are less readable (and maybe slower). > I know that this response was directly related to a question about subqueries, but I think it's important to point this out, because I alm

Re: Technical Clarification

2001-03-18 Thread Fred van Engen
Hi Kathir, On Mon, Mar 19, 2001 at 05:38:55AM -, Rama kathiresan kathiresan wrote: > This is kathir from Uniware Systems, We are developing project on ASP with Backend >as MySQL, We having a problem using "IN" and "NOT IN" operators in sub query > ... > iam selecting the values from 3 dif

Technical Clarification

2001-03-18 Thread Rama kathiresan kathiresan
hi, This is kathir from Uniware Systems, We are developing project on ASP with Backend as MySQL, We having a problem using "IN" and "NOT IN" operators in sub query here i am listing my query as follows: "select c.pickupdate,c.contno, r.relrefno, r.custname, r.contsize, r.conttype, r.qtybooke

RE: Technical Clarification

2001-03-12 Thread Cal Evans
inath [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:16 AM To: [EMAIL PROTECTED] Subject: Technical Clarification Hi, We are doing a project with combination of ASP & MYSQL (backend). We are having some problem for setting relationship between the tables. We have to know whethe

Technical Clarification

2001-03-12 Thread gopinath
Hi, We are doing a project with combination of ASP & MYSQL (backend). We are having some problem for setting relationship between the tables. We have to know whether foreign key will be supported in MySQL and we came to know that there is no use for foreign key(as per your documentation: The

Technical Clarification

2001-02-18 Thread Jonas Norrman
Hi, > "gopinath" == gopinath <[EMAIL PROTECTED]> writes: gopinath> Hi, Is there any optimization tool for MySQL database , so gopinath> that it can be fast? gopinath> Please let us know as we are uploading our site using MySQL. gopinath> Regards gopinath> Gopinath Transitional//EN">c

Technical Clarification

2001-02-18 Thread gopinath
Hi, Is there any optimization tool for MySQL database , so that it can be fast? Please let us know as we are uploading our site using MySQL. Regards Gopinath

Re: Technical Clarification

2001-02-12 Thread Teddy A Jasin
You can save the excel file in csv format (delimited text) and upload it to mysql using load data. Or the easiest use phpmyadmin Teddy - Original Message - From: "gopinath" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 7:27

Technical Clarification

2001-02-12 Thread gopinath
Hi, We have uploaded our site that uses Chilisoft ASP with MySQL backend database.We are now in testing stage.It works fine with just 10 records in each table. We have our original data in Excel. Now how do we convert that excel data to mysql data (which is in bulk.) and upload . The main iss