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

RE: Technical Clarification

2001-03-12 Thread Cal Evans
Greetings and salutations, MySQL Supports FKs. A FK is a table's PK value, stored in another table in order to relate the records together. It does NOT support FK CONSTRAINTS. (Cascading deletes, restricts, etc.) ...and now for the opinion portion of our show... For all the of databases I've w

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 PM Subject: Technical Clarificati