Organic Search Agency

  Aholt: Wrksx: They can be workarounded with foreign keys, but that's another story Kilkus: Salle, I'm lucky IFs are supported = Tio: Curmet, do you know how multicolumn composite indexes work? you will need them Carel: ERROR 29 HY000: File './mysql-relay-bin.~rec~' not found Errcode: 13 Dillen: Why is it…

  Supernaw: So the GROUP dont will work Labrake: SamSagaZ: Your entire question was about t2. Fventes: SamSagaZ: MAX is only part of the solution. If you need other columns in t2, max will produce a value that can be used in a subsequent join. That's one of the "groupwise…

  Yerka: SamSagaZ: You need explicit data that allows you to represent the concept of "newest" or "age". Baetz: SamSagaZ: Without that, you can't have logic involving age or newest. Pindell: Trying to fill the sqlfille Crew: Http://sqlfiddle.com/#!9/173e6/3 Sleger: Btw, very nice site sqlfiddle.com! Trepagnier: Reading roupwise max now Garhart:…

  Bartolomeo: Xgc: What is the correct way to inherit? Vanfossen: Brunoalano: In your model, user does not inherit from employee and employee does not inherit from user. You need another object / table that holds the common detail for both, but none of the unique detail for each. Osberg:…

  Soong: I have a job_requests table Buetti: Farra_000: just curious, but why are you asking Bridendolph ? Hamersly: Bc the error message says I have a SQL problem Buetti: Rakm: no, you cannot alter the data in a table referenced in a subquery Ruff: Hmm ok. is there another…

  Okoye: If I have tables users and posts and posts.user_id is a column. The foreign key should go onto posts and the "referenced table" is users correct? Buetti: Fk constraints are defined in the child table and reference the parent Haywood: Why does the database need to check if…