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
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)
,
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 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:
- 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