|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?|
|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.|
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.
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'.
|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|
|Xgc||Drstroker: You do that with a union.|
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.
but as a union i only dervive one column correct