Organic Search Agency

  Correl: Scott0_: In both cases it does not matter at all how the expressions are written in the WHERE Keiter: Well, salle is trying to trick you a bit. Albritton: Why would b,a be better for the latter conditions? Keiter: Scott0_: because the range check is with a. Correl:…

  Nies: I was asking about my recollection hoping there would be a simple response like darwins Correl: Scott0_: Same question again: If you have WHERE a = 1 AND b = 2; what makes you ***ume it matters if your index is a,b or b,a ? Onukogu: Because I…

  Correl: Scott0_: The order of items in the WHERE clause does not matter if the end result is the same boolean value Eavenson: If I search by WHERE a=1,b=2,c=3 vs b=2,a=1,c=3 Correl: Scott0_: Zero difference Reynalds: So if one of those orders would be better on the index, why…

  Wittmann: Such that cascading to them might change something Castilla: Ahhhhh i hadn’t considered that. Correl: Aeiou: You said you get FK error, but your table does not have FK constraint. Correl: Aeiou: Whenever you get FK error you check the other table too Correl: Aeiou: Simplest example is…

  Pullar: Well if is that simple it seems like the answer is not that simple then Correl: SmashingX: Stop arguing and learn joins Keiter: SmashingX: all right, it's getting old. Hoying: Because we would be arguing for all this time Correl: SmashingX: The answer is very simple : Keiter:…

  Krise: Salle: what is it generated by, InnoDB? Keiter: SmashingX: why do you think you don't need a join? Correl: SmashingX: Joins in SQL are like steering wheel for car driving Wortham: I don't know that's why Im asking here thumbs Keiter: SmashingX: use a join. Correl: SmashingX: Would…

  Schiffert: Lmat: these roll-your-own functions/procedures have a serious problem in that it seems like they try to select from mysql.user first to see "if the user exists". but normally someone really shouldn't need permission to read from mysql.user to be able to issue GRANT or DROP USER statements .…

  Brittman: 13:41 SmashingX in the table and the referenced table do not match for constraint. Brittman: SmashingX: no problem, thanks for pasting us the answer! ; Mcquiston: Trying to run a mysql from command line and I need to figure out how to limit my results to records created…

  Cloward: Brittman: Ok, I'll revert to a copy before I did the upgrade of FreeBSD. Soyars: Sorry such a noobie question Prophit: Izham: InnoDB offers ACID transactions, foreign key constraints, and robust crash recovery. Generally a good default unless something specific requires MyISAM. Sensenbrenner: Does MySQL handle refering to…

  Devault: I get nothing when I try those, mgriffin Edgley: Brittman: I tried without the grep part and still get nothing. Inlow: I am trying to understand if MySQL is smart enough to handle binary logging correctly in this situation. We have bin logging enabled and set to mixed.…