153 reputation
7
bio website
location
age
visits member for 2 years, 10 months
seen Aug 25 at 9:41

IBM Worklight

HTML, Javascript, jQuery, CSS

iOS, Android

PHP, Yii, MySQL


Sep
24
awarded  Autobiographer
Feb
3
comment Group by reversible pair
Thank you. It looks good, however I took a simpler approach by getting some help from php. I created a hash combining both user ids (stackoverflow.com/questions/21515318/…) and used that to identify each conversations. I added a conversation field, and was able to use a simple GROUP BY conversation.
Feb
3
comment Group by reversible pair
I took a different approach, I created a hash combining both user ids (stackoverflow.com/questions/21515318/…) and used that to identify each conversations.
Feb
3
comment Group by reversible pair
yes @ypercube .
Feb
2
comment Group by reversible pair
I want show them (not individual messages, but conversations, sorted by latest activity)
Feb
2
asked Group by reversible pair
Oct
28
awarded  Popular Question
Feb
19
awarded  Commentator
Feb
19
accepted Create a VIEW that spans 3 tables
Feb
19
comment Create a VIEW that spans 3 tables
I went with Option 2. Using "explain" also made it seem better to use option 2.
Feb
19
comment Create a VIEW that spans 3 tables
"There's not really a strong case here for doing this with views" - I'm doing this simply to make coding simpler, instead of storing this query.
Feb
18
revised Create a VIEW that spans 3 tables
added 651 characters in body
Feb
18
revised Create a VIEW that spans 3 tables
added 64 characters in body
Feb
18
revised Create a VIEW that spans 3 tables
deleted 99 characters in body
Feb
18
asked Create a VIEW that spans 3 tables
Dec
30
comment MySQL Workbench sync keeps requesting the same changes
5.1.53 on OSX ..
Dec
27
comment MySQL Workbench sync keeps requesting the same changes
Yes, 5.2.44 for OSX
Dec
27
asked MySQL Workbench sync keeps requesting the same changes
Nov
20
comment View for a MANY_MANY_MANY relationship
Edited my answer. Is this a good solution now?
Nov
20
awarded  Editor