#mysql - Mon 23 Apr 2007 between 05:22 and 05:44

NY Lost Funds



edgecastXgc: Is there an alternative paste site? looks like pastebin is having trouble (Query failure: Can't open file: 'pastebin.MYI'. (errno: 145))
supergregedgecast: http://mysql.paste-bin.com/
Xgc: I'm sorry, it is a bit beyond my scope, this. I would like to understand though..
edgecastXgc: Thanks! http://mysql.paste-bin.com/11464
Xgcsupergreg: SELECT derived_table.*, properties_details.re_value FROM (your original select of MAX(properties_details.id) as maxId, properties_details.property_id) AS derived_table JOIN properties_details ON properties_details.id=derived_table.maxid;
supergreg: Make sure you place the entire SQL with group by inside the derived_table.
edgecast: 2.23.* could have all sorts of old bugs.
edgecast: Sorry... 3.23.* could have all sorts of old bugs.
chadmaynard3.23 allows subqueries?
Xgcedgecast: Also, MyISAM has no foreign key constraint support.
chadmaynard: No.
chadmaynardi didn't think so
supergregXgc: Thanks, I will try this and that with that code, as I really dont get what it does yet. *testing*
Xgcedgecast: ... .. if I remember correctly, that is.
chadmaynardabout the FKs?
H1pp1eedgecast, for use foreing key use InnoDB.
InnoDB support foreing keys
create table name_table{
create table name_table( ... ) TYPE=InnoDB;
XgcSorry. edgecast didn't ask about FKs.
actionXgc lost track.
Xgclost track.
edgecastnp ... just trying to see if I can get it on a 4.1 server
chadmaynard4.1 is golden
Xgcedgecast: The problem doesn't exist in 5.0. This is probably just a 3.x bug.
chadmaynardwhat problem are we talking about? I have a 3.23
edgecastThanks guys
H1pp1eDoes anyone know a way to detect EOF of a cursor without using handlers?
Xgcchadmaynard: Try his post. He says the ON clause causes an error.
H1pp1eDoes anyone know a way to detect EOF of a cursor without using handlers?
actionchadmaynard looks for a post
chadmaynardlooks for a post
Xgcchadmaynard: http://mysql.paste-bin.com/11464
edgecasthttp://mysql.paste-bin.com/11464
actionchadmaynard ahhhs
chadmaynardahhhs
Xgcedgecast: It'll probably work if you move the ON condition into the WHERE clause and replace the JOIN with , (comma)
edgecast: SELECT ... FROM t1, t2 WHERE t1.blah=t2.blah AND t2.cond=5;
edgecastXgc: No errors that way! Can that be considered an identical query?
actionsupergreg aaaahs
supergregaaaahs
edgecastYou should generally not have any conditions in the ON part that are used to restrict which rows you want in the result set, but rather specify these conditions in the WHERE clause. There are exceptions to this rule.
actionsupergreg does happy-dance
supergregdoes happy-dance
edgecastForgot quotes: MySQL Docs "You should generally not have any conditions in the ON part that are used to restrict which rows you want in the result set, but rather specify these conditions in the WHERE clause. There are exceptions to this rule."

Page: 2 9 16 23 30 37 44 

IrcArchive

NY Lost Funds