Surge 2011 CFP Deadline Extended
OmniTI is pleased to announce that the CFP deadline for Surge 2011, the Scalability and Performance Conference, (Baltimore: Sept 28-30, 2011) has been extended to 23:59:59 EDT, April 17, 2011. The event focuses upon case studies that demonstrate successes (and failures) in Web applications and Internet architectures. New this year: Hack Day and Unconference on September 28th. For information about topics: http://omniti.com/surge/2011. Get inspired by the 2010 sessions, now online at (http://omniti.com/surge/2010) 2010 attendees compared Surge to the early days of Velocity, and our speakers received 3.5-4 out of 4 stars for quality of presentation and quality of content! Nearly 90% of first-year attendees are planning to come again in 2011. For more information about the CFP or sponsorship of the event, please contact us: surge (AT) omniti (DOT) com. -- Katherine Jeschke Marketing Director OmniTI Computer Consulting, Inc. 7070 Samuel Morse Drive, Ste.150 Columbia, MD 21046 O: 410/872-4910, 222 C: 443/643-6140 omniti.com circonus.com
Ordering by grouping
Once more I am surprised by the ordering that I get from 'GROUP BY'.
This defines the table of directors that have been on the board:
CREATE TABLE DIRECTOR
( Chosen DATE NOT NULL
, Through DATE NOT NULL
, MemberIDINTEGER REFERENCES MemberAddress (MemberID)
, CONSTRAINT dpk PRIMARY KEY (Chosen, MemberID)
, RankTINYINT REFERENCES MemberName (Rank)
)
This query, based also on a view ('offboard') that joins this table with
nameaddress tables, lists the boards that arise from the table:
select When, COUNT(givenname || ' ' || surname) AS directors,
group_concat(givenname || ' ' || surname ORDER BY Surname) AS Board
FROM (select distinct chosen AS When
FROM director
UNION select distinct ADDDATE(through, 1)
FROM director
WHERE through CURDATE()) as B JOIN offboard ON When between chosen
and through
GROUP by When
It is only roughly, not completely, ordered by 'When'. Why? When is
'GROUP-BY' ordering complete?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Ordering by grouping
Mildly surprised this is working at all. Your name alias fields like
When should be quoted by back-tics, no double quotes.. this is a
clarification and does not solve the issue really although it might
make your final result less surprising.
A key thing to note about GROUP BY is that, although it uses ordering
internally to do it's work, it is not an ORDER BY clause and does not
pretend to make guarantees as to the order of the resulting data. If
you need ordering, add an ORDER BY clause after your GROUP BY.
- michael dykman
On Fri, Apr 8, 2011 at 8:51 AM, h...@tbbs.net wrote:
Once more I am surprised by the ordering that I get from 'GROUP BY'.
This defines the table of directors that have been on the board:
CREATE TABLE DIRECTOR
( Chosen DATE NOT NULL
, Through DATE NOT NULL
, MemberID INTEGER REFERENCES MemberAddress (MemberID)
, CONSTRAINT dpk PRIMARY KEY (Chosen, MemberID)
, Rank TINYINT REFERENCES MemberName (Rank)
)
This query, based also on a view ('offboard') that joins this table with
nameaddress tables, lists the boards that arise from the table:
select When, COUNT(givenname || ' ' || surname) AS directors,
group_concat(givenname || ' ' || surname ORDER BY Surname) AS Board
FROM (select distinct chosen AS When
FROM director
UNION select distinct ADDDATE(through, 1)
FROM director
WHERE through CURDATE()) as B JOIN offboard ON When between chosen
and through
GROUP by When
It is only roughly, not completely, ordered by 'When'. Why? When is
'GROUP-BY' ordering complete?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Any table visualization tools with wires connecting the actual columns?
It only seems to do the lines for InnoDB tables, not MyISAM... I mean, it not only won't auto-connect them, it won't even allow ME to connect them. :( Thanks though. -Original Message- From: mos [mailto:mo...@fastmail.fm] Sent: Thursday, April 07, 2011 8:50 PM To: mysql@lists.mysql.com Subject: RE: Any table visualization tools with wires connecting the actual columns? At 05:36 PM 4/7/2011, Daevid Vincent wrote: I am a paid subscriber to SQLYog -- I love that tool, but AFAIK it doesn't do diagrams (with wires between tables and all that glory). Am I wrong? Is that feature there and I just never noticed it? David, SqlYog Ultimate has a schema designer. Take a look at the screen shots. http://www.webyog.com/en/screenshots.php Mike -Original Message- From: mos [mailto:mo...@fastmail.fm] Sent: Thursday, April 07, 2011 1:36 PM To: mysql@lists.mysql.com Subject: Re: Any table visualization tools with wires connecting the actual columns? At 02:17 PM 4/7/2011, Daevid Vincent wrote: Does anyone have any suggestions on this? I've written to SQL Maestro twice and they've not replied either. Take a look at SqlYog from www.webyog.com. I use their community version but their paid version has a schema designer. They are responsive to emails and forum posts. Mike From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Friday, April 01, 2011 4:27 PM To: mysql@lists.mysql.com Subject: Any table visualization tools with wires connecting the actual columns? I am evaluating various tools for diagram generating of existing databases on some smaller databases (9 tables or so) first. The two I've tried so far are these: http://dev.mysql.com/downloads/workbench/ http://www.sqlmaestro.com/download/#mysql Both _seem_ robust and cosmetically polished, but feel to me lacking the most obvious and key component of the whole purpose to make an EER diagram. I don't understand in workbench, why it creates new keys for me on existing tables. Maestro doesn't do this nonsense. It isn't the tools business where I have keys, it only needs to be concerned with what links to what -- that I tell it to. It's further exacerbated by the fact that the documentation indicates these aren't even REAL keys, they are cosmetic only! WTF? Why add confusion guys? 1. Neither one seem to be smart enough to automatically know that columns of the same name should be linked, and furthermore they should be linked from all tables to the one where that column name is the PK. my tables don't have true InnoDB FKs setup. And some tables are MYISAM (as they're significantly faster). But I do use keys and I do have sane naming conventions, so I don't understand why they can't use the names, and if there are multiple tables (for some unlikely reason) then just prompt me which table to use. Which leads me to the second and third problems... So I manually have started to draw the connections, but: 2. How can I make the wires stick to a column on the left or right edge, so that I can have a direct visual link between the columns. Right now, it seems they float around the edge of the table box. That's sort of useless isn't it? it's like saying, well, something in this table points to something in that table.?! I would think that two programs with such high version numbers would have this feature. Maybe I'm missing a configuration or some way I'm supposed to do it? 3. Some of my databases point to tables in other databases on the same server. It would be useful if I could make a wire that indicates this. Are there other (better) options out there for this? I really don't want to do this in Visio or make a printout of the table boxes and tape string to my walls to visualize all the databases, tables and columns. -Daevid. _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3544 - Release Date: 04/01/11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3544 - Release Date: 04/01/11 _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3557 - Release Date: 04/07/11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:
Re: Any table visualization tools with wires connecting the actual columns?
- Original Message - From: Daevid Vincent dae...@daevid.com It only seems to do the lines for InnoDB tables, not MyISAM... I mean, it not only won't auto-connect them, it won't even allow ME to connect them. :( Probably because it wants to adhere to the engine capabilities, and MyISAM doesn't have referential integrity. MySQL Workbench seems to do it right, though. It may or may not complain at apply time, but it does seem to save the relations you set, even for MyISAM tables. See attached file as example :-) The tool is freely downloadable from the MySQL site. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel test.mwb Description: Zip archive -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
