RE: UNIONS & 'Got error 12 from storage engine'

2005-04-20 Thread Mechain Marc
Memory problem. Error 12 = Cannot allocate memory Marc. -Message d'origine- De : Cliff Daniel [mailto:[EMAIL PROTECTED] Envoyé : jeudi 21 avril 2005 07:43 À : mysql@lists.mysql.com Objet : UNIONS & 'Got error 12 from storage engine' Have a query that consists of 10 unions. For a peri

Re: unions will full column names won't work in 4.1.7

2004-12-15 Thread Rhino
- Original Message - From: "Kevin A. Burton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 15, 2004 7:23 PM Subject: unions will full column names won't work in 4.1.7 > Not sure if this is a bug... probably should be. > > On 4.1.18 I can run: > > (SELECT * FROM F

Re: unions will full column names won't work in 4.1.7

2004-12-15 Thread Paul DuBois
At 16:23 -0800 12/15/04, Kevin A. Burton wrote: Not sure if this is a bug... probably should be. On 4.1.18 I can run: 4.1.18? I assume you mean 4.0.18. Anyway, what you describe is according to the documentation: http://dev.mysql.com/doc/mysql/en/UNION.html (SELECT * FROM FOO WHERE ID = 1) UNION (

Re: Unions

2002-06-27 Thread Alexander Barkov
[EMAIL PROTECTED] wrote: >>Does anyone else feel that lack of support for subqueries is the number 1 >>deficiency in MySQL? I'm not sure why support for subqueries is being > > > Actually, I am much more eagerly waiting for views and Unicode > support that sub-selects, although of course these

RE: Unions

2002-06-27 Thread Darley, Terry
they neglected one of the most fundamental SQL capabilities. There must be a good reason !!! ??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 27 June 2002 17:10 To: [EMAIL PROTECTED] Subject: RE: Unions > Does anyone else feel that lack of support for subquerie

RE: Unions

2002-06-27 Thread dvorakv
> Does anyone else feel that lack of support for subqueries is the number 1 > deficiency in MySQL? I'm not sure why support for subqueries is being Actually, I am much more eagerly waiting for views and Unicode support that sub-selects, although of course these would be very nice too. Vaclav Dv

RE: Unions

2002-06-26 Thread Charles Ocheret
aul DuBois Subject: Re: Unions But MYSQL4.0 is currently in its Alpha ... Any idea when the Release of 4.0 would be made.. Also any idea about 4.1 Release reg when it would be coz i am eagerly expecting for subqueries in MYSQL -Arul - Original Message - From: "Paul DuBois" &l

Re: Unions

2002-06-26 Thread Ralf Narozny
Hiho hiho! How about: CREATE TABLE tmp_whatever SELECT FROM table1... INSER INTO tmp_whatever SELECT FROM table2... ? Greetings Ralf P.S.: A bit dirty for someone who got used to Oracle ;-) Arul wrote: >Hi > >Can i use Unions in MySQL. >If not could anyone comeout with some alternates.

Re: Unions

2002-06-21 Thread Veysel Harun Sahin
Take a look at "http://www.mysql.com/doc/";. If you search the keyword union you can get an answer. Arul wrote: >Hi > > Can i use Unions in MySQL. > If not could anyone comeout with some alternates.. > > Regards, > -Arul > >sql, > > >--

Re: Unions

2002-06-21 Thread Roger Baklund
* Arul > Can i use Unions in MySQL. >From version 4 you can: http://www.mysql.com/doc/U/N/UNION.html > > If not could anyone comeout with some alternates.. The normal workaround is to use temporary tables: create temporary table t1 select ...; insert into t1 select ...; select * from t1;

Re: Unions

2002-06-01 Thread Richard Clarke
They are bugged in 4.0.1 (apparently fixed in 4.0.2) so I wouldn't rely on them too much. Richard - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 01, 2002 11:33 AM Subject: Re: Unions > A

Re: Unions

2002-06-01 Thread Victoria Reznichenko
Arul, Saturday, June 01, 2002, 9:26:48 AM, you wrote: A> Is there anything Equivalent in MYSQL for Union in Oracle.. A> As per my understanding mysql doesnt support unions ...so any suggestions A> what could be done.. MySQL supports UNION since 4.0.0. Look at: http://www.mysql.com/doc/U/N