I'm using MySQL 5.0.92-log.
I'm trying to do a pivot-sort-of-thing. I've tried a few things from the
O'Reilly SQL Cookbook, but I seem to be having a mental block.
I have a table of farm harvests. Each harvest has a date, quantity, and foreign
keys into product and harvester tables:
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 all
I want to create a table with a long varchar column, maybe it's the url.
according to dns spec, the url's max length is fixed. but I have
to deal with url having long params such as
a.html?q=fl=
I want the url is unique