| asdx | oh that did it :) insert into user (host, user, password) values ('localhost', 'asdx', PASSWORD('blah')); flush privileges; i will see GRANT/CREATE USER later thanks for the help |
| Frosh | are there programming in mysql? |
| asdx | Frosh: programming in mysql? |
| brian_lucid | frosh: http://tinyurl.com/2wlx5s |
| Drstroker | Xgc: lol you have me on the edge of my seat |
| Xgc | Drstroker: After all that, I'm trying to find a path for you to follow to the solution. I have the answer. Blurting it out doesn't seem like the right thing to do. Let's see... Drstroker: The first step is to realize the schema doesn't quite provide the structure you need. |
| asdx | damn i cant create databases with my user |
| Xgc | Drstroker: You want to conditionally join on column 1 or column 2. |
| asdx | is that some permission i have to change? |
| Xgc | Drstroker: user_id or boomer_id. |
| Drstroker | um yes correct between there user_ids |
| Xgc | Drstroker: So start by constructing a result set with both [user_id, boomer_id] and [boomer_id, user_id] tuples. Drstroker: Do that with a union. |
| Drstroker | wait what lost me now |
| Xgc | Drstroker: The key is you also want the original boomer_id and user_id in the same result, not swapped. Drstroker: Well, you want to find all boomer_user entries where boomer or user is '1'. |
| Drstroker | yes well |
| Xgc | Drstroker: To do that cleanly, you want to construct a set where both boomer and user are found in the join key/field. |
| Drstroker | all users_boomers where user_id or boomer_id = 1 and boomer_status_id = 1 yes |
| Xgc | Drstroker: You do that with a union. |
| Drstroker | right! i've done that correct? |
| Xgc | Drstroker: At the same time you want to return the original user, boomer fields in separate columns in the original order. Drstroker: derived table looks like this: user/boomer, boomer/user, user, boomer |
| Drstroker | sorry i'm lost now |
| Xgc | Drstroker: The first 2 columns are generated from the sides of the union. SELECT user, boomer, ... FROM ... UNION SELECT boomer, user, ... Sorry. There's a typo in that description. |
| Drstroker | yes correct i'm sorry but as a union i only dervive one column correct |