mysql server crash on nested selects (fwd)

-- Forwarded message -- Date: Mon, 7 Mar 2005 15:54:11 -0800 (PST) From: Ronald Braunstein <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: mysql server crash on nested selects >Description: Server crashes. This crashes the following servers:

different kind of nested selects

Let's say I have two tables: T1: Name --- apple banana cherry T2: value| name -|-- 1 | apple 2 | banana 3 | banana 4 | cherry 5 | apple 6 | apple I want to get a result that looks like this: name| all_values apple| 1,5, 6 banana| 2,3 cherry| 4 In my head, t

Using like in with nested selects

Hello, I have a problem. I have two tables one with the long sentences(TABLE 1) and one with the words in that sentences(TABLE 2). what i need to do is query the TABLE 2 by giving a part of the word ---WILD CARD MATCHING-and get the complete words which contains this part. Then Use thi

Nested SELECTs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello-- I'm developing a client for a box office that uses MySQL as the backend. I *was* using Access (yes, bad idea) but having converted to MySQL I'm finding that I have to rewrite some nested SELECTs that MySQL barfs on. Some of the q

RE: nested selects

> Cal Evans writes: > > Sinisa, > > > > Is there a published list of features for 4.0? > > > > Cal > > http://www.calevans.com > > > > > It is not complete yet. > > But, new .frm files, multi deletes and updates from joins, UNION's and > many others. And are there any dates, even tentativ

RE: nested selects

Cal Evans writes: > Sinisa, > > Is there a published list of features for 4.0? > > Cal > http://www.calevans.com > It is not complete yet. But, new .frm files, multi deletes and updates from joins, UNION's and many others. Regards, Sinisa __ _ _ ___

RE: nested selects

Sinisa, Is there a published list of features for 4.0? Cal http://www.calevans.com -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 8:06 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: nested selects

RE: nested selects

Cal Evans writes: > If you mean: > Select * from table where tableID in (Select tableID from table2); > > Then no, MySQL does not support them. They mythical version 4.0 might. :) > > Cal > http://www.calevans.com > Actually, they will be in 4.1. And the above query does not need

RE: nested selects

AM To: '[EMAIL PROTECTED]' Subject: nested selects Is mySQL able to perform nested selects? If so can anyone provide me with an example If not can you provide an alternate solution Thanks Philip - Before posting, pl

nested selects

Is mySQL able to perform nested selects? If so can anyone provide me with an example If not can you provide an alternate solution Thanks Philip - Before posting, please check: http://www.mysql.com/manual.php (the manual