| craigbass1976 | I'm having trouble with a query. query and error are here: http://rafb.net/p/lgkQ0A63.html |
| ray|away | craigbass1976: GROUP BY batches.sell |
| aoirthoir | craigbass1976: you cant mix group fields |
| brutuz | would there be a difference in speed if you do "between" and "Comparison1 and Comparison2" |
| craigbass1976 | aoirthoir, what do you mean? What is mixing group fields? |
| aoirthoir | craigbass1976: your max(batches.sell) is a group field max gets the highest value from the batches.sell field so its a group field.. so for instance iuf you have five records..with fields row, and age er fields name and age |
| craigbass1976 | so how would I return the record with the highest price in this query? |
| aoirthoir | john, 20, bob, 50, scott, 30... you do a group by |
| craigbass1976 | aoirthoir, Like this? http://rafb.net/p/Hh2tu785.html |
| aoirthoir | craigbass1976: give me a sec ok here is the thing craig... http://rafb.net/p/cyPiVT43.html see if that works |
| craigbass1976 | I get a "can't group on mytotal" |
| aoirthoir | sorry bra maybe tomorrow morning when i am more awake i can help you better |
| craigbass1976 | Another problem, the results I get after getting the whole batches thing out of there are screwy. I'm getting a bunch of items, but they all have the same id, when in fact they don't... hmmm |
| YangYin | hello everyone... i am a little new to this database... i just created a database on my web hosting server and i was wondering if there was a default password not password but login |
| aoirthoir | you have to check with your web hosting service |
| YangYin | damn cause they charge 75$/hr for database questions |
| Agrajag- | g'day. my replication slave has stopped, the error is "Error 'Column 'award_id' cannot be null' on query. Default database: 'workbuddy_core'. Query: 'insert into award_level_group (award_id, award_group_name, award_group_code, parent_award_group_id) values(@award_id , "Personal Training 3 visits 1 on 1", "PT3-1/1", @casual)'". this query didn't fail on the master is this because of the use of @variables? is there any way around this? i had a look at the script that the person used who ran the query. they first had a select which did "select @award_id := ..." then they did the insert statement. im guessing because the select doesn't happen in the binlog, the @award_id variable never got set, hence the error on the slave there's got to be a way around this? |
| StuBo | Repair with keycache is tha the bugger that takes days on a large table ? myisam of course |
| vice-versa | StuBo: yup |
| [domon] | i have never used the commandline for mysql administration - what is the command to create a user "user" with password "password" |
| capuchin | i am experiencing mysqld dying unexpectedly and see this in syslog "VM: killing process mysqld" ... any pointers? |
| vice-versa | [domon]: help create user or help grant |
| StuBo | vice-versa: if I kill my process thats doing my alter table, the one thats doing the 'Repair with Keycache' |