how to create unique key for long varchar?

2013-11-04 Thread Li Li
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 whe

Re: Another query question...

2013-11-04 Thread Reindl Harald
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. > >

Re: Another query question...

2013-11-04 Thread hsv
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 some

Another query question...

2013-11-04 Thread Jan Steinman
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 "201

Re: Another query question...

2013-11-04 Thread Jan Steinman
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 t

Pivot Query Help

2013-11-04 Thread Jan Steinman
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: -