2013/11/08 17:35 -0800, Jan Steinman
Okay, I think I found it:
http://bugs.mysql.com/bug.php?id=47713
I added a comment with a link to a page I set up to show the behaviour on my
system.
http://www.ecoreality.org/wiki/WITH_ROLLUP_problem
It was submitted in 2009, severity
From: h...@tbbs.net
2013/11/04 09:32 -0800, Jan Steinman
I noticed that I have similar queries that work as expected. The difference
appears to be that every query that is broken uses WITH ROLLUP, and
removing this makes them behave as expected.
Is this a known bug? Should I submit it
The plot thickens...
I noticed that I have similar queries that work as expected. The difference
appears to be that every query that is broken uses WITH ROLLUP, and removing
this makes them behave as expected.
Is this a known bug? Should I submit it as such?
If someone would be so kind as to
MySQL 5.0.92-log
I'm trying to form a clickable link using CONCAT, but the link as displayed
points to the NEXT row's URL, not the one from the same row as the other data
displayed!
Is there something I don't understand about this?
Below is the query. {{{1}}} is replaced by a year, like 2013.
2013/11/04 09:32 -0800, Jan Steinman
I noticed that I have similar queries that work as expected. The difference
appears to be that every query that is broken uses WITH ROLLUP, and removing
this makes them behave as expected.
Is this a known bug? Should I submit it as such?
If someone would
Am 04.11.2013 22:55, schrieb h...@tbbs.net:
2013/11/04 09:32 -0800, Jan Steinman
I noticed that I have similar queries that work as expected. The difference
appears to be that every query that is broken uses WITH ROLLUP, and
removing this makes them behave as expected.
Is this a known
Hi everyone and thanks in advance for the help. I have a query that I'd like to
perform using two tables but am not sure what the best way to perform it short
of creating a loop in my code and performing multiple queries.
I have two tables. The first table acts as a master table of sorts and
You'll need to use the technique described here:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
-Original Message-
From: Michael Stroh [mailto:st...@astroh.org]
Sent: Monday, July 26, 2010 2:50 PM
To: MySql
Subject: Yet another query question
Hi everyone
Aren't you grouping on IDt?
something like ? :
select t2.IDt,t2.ID,t2.Num,max(t2.version) from table1 as t1, tabl2 as t2
where t1.num=t2.num and t1.state!='new' group by t2.IDt
Cheers,
Geert-Jan
2010/7/26 Michael Stroh st...@astroh.org
Hi everyone and thanks in advance for the help. I have a
Yes, sorry, you are correct. I am actually grouping on that other column. I'll
take a look at this and see if it works for me. Thanks!
Michael
On Jul 26, 2010, at 6:10 PM, Geert-Jan Brits wrote:
Aren't you grouping on IDt?
something like ? :
select t2.IDt,t2.ID,t2.Num,max(t2.version)
I am using MySQL 4.0.x on a Linux machine with a JSP/Servlet front-end to
display the data.
I have a table with experimental data for each flight of a rocket.
Conceptually, it looks like (with many more columns):
Flights
+---+--+--+
| flight_id | data1_id | data2_id |
Mark Phillips wrote:
Flights
+---+--+--+
| flight_id | data1_id | data2_id |
+---+--+--+
| 1 |1 |1 |
| 2 |1 |3 |
| 3 |1 |1 |
| 4 |2 |2 |
| 5 |
Mark Phillips wrote:
2. Generally, what is the most efficient way to do this? Is is better to
issue more queries that gather the calculated data or better to issue one
query for the raw data and then do the calculations in Java? I am sure there
are many factors that effect the answer to
Mark Phillips [EMAIL PROTECTED] wrote on 12/14/2005 11:31:03
AM:
I am using MySQL 4.0.x on a Linux machine with a JSP/Servlet front-end
to
display the data.
I have a table with experimental data for each flight of a rocket.
Conceptually, it looks like (with many more columns):
PM
To: MYSQL List
Subject: YAQQ (Yet Another Query Question)
I am using MySQL 4.0.x on a Linux machine with a JSP/Servlet front-end to
display the data.
I have a table with experimental data for each flight of a rocket.
Conceptually, it looks like (with many more columns):
Flights
Nigel,
Thanks!
Mark
On Wednesday 14 December 2005 09:42 am, nigel wood wrote:
Mark Phillips wrote:
Flights
+---+--+--+
| flight_id | data1_id | data2_id |
+---+--+--+
| 1 |1 |1 |
| 2 |1 |
Nigel,
Again, thanks - that is the rule of thumb I was looking for!
Mark
On Wednesday 14 December 2005 09:57 am, nigel wood wrote:
Mark Phillips wrote:
2. Generally, what is the most efficient way to do this? Is is better to
issue more queries that gather the calculated data or better to
Thanks to everyone for their help. Using Nigel's suggestion, I was able to
gather all the summary data in one query. Those nested if()'s are really
useful!
FWIW, you can see the summary stats at http://rockets.phillipsoasis.com
Just click on Hopi Rockets and scroll to the bottom of the page. My
18 matches
Mail list logo