Rumery: LucaS05, is it not like a foreign key?
Tazelaar: I will try to give you an example
Bonardi: There are no check constraints in mysql, you can use a trigger for that
Maricle: Rumery: what i was talking about is that i can’t have this situation: http://imgur.com/2a7h896
Rheaves: I mean that a sell can’t have an agent and a client that belongs to another agent
Heindl: Hope you understand 😀
Rhome: Use a composite foreign key constraint
Paeth: But it is more correct to remove Agent column from sells
Rumery: Or do not store the agent if it is “derivable” from the client
Thibaut: Rumery: jesus redundancy.
Weir: You’re right! Thanks ; I was thinking at the complex solution.
Rumery: LucaS05, not properly normalized = data with artifacts.
Poormon: What you mean with data with artifacts?
Rumery: JesusTheHun, ah, checking again, you say “lowest rank for each csc, token” but in your example schema “csc, token is unique” – so there can be only one rank per each combination, no way to get more of them at all
Rumery: LucaS05, sorry, used wrong word, I meant “update anomaly” – https://en.wikipedia.org/wiki/Database_normalization#Free_the_database_of_modification_anomalies
Seltz: The value of discussion is underrated
Laffredo: I’m having trouble finding an answer or finding the proper question to ask google for comparing table1.email with table2.email and return table1.* if table.email is in table2.email
Frates: I’ve done it before years ago and now I can’t find it again
Aimone: Verumequals: http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
Sherer: Rumery: thanks for pointing this out
Husanini: Hi guys :, do you guys happened to know a good resource for understanding mysql, the inner working. thx before :
Padmore: Boleware: so I can really understand how mysql functions in order to tune the performance.
Birdsall: That’s different from “inner working”
Colonna: Read High Performance Mysql book
Sandin: Damn, was about to recommend it
Wetter: I have this query http://laravel.io/bin/PXJD5 it is bringing one single record from attendees table when I know there are more records matching
Mital: ArtisanIndia: don’t pastebin app code, we have no way of knowing if your variables contain the values you imagine they do. Echo the query out to SQL only. Also, pastebin any resulting error message, or, if none, explain why you think you’re getting different results than you should have.
Barzey: And format it better to make it readable
Buchann: Show create table X ; to get schema and then select * from X limit 50 to get sample of data
Moro: Boleware: thx :. any good resource for the inner working also? Because I just started a job as a db admin
Lutgen: Asasmita: you won’t have time to read 2 books
Nylander: Boleware: don’t cap people :
Neyhart: Jesus first 7-8 lines are just selecting column name
Apley: So you can ignore them
Sundberg: ArtisanIndia: you get one row per event, because you use GROUP BY events.id
Upton: I won’t help you unless you put a sample on sqlfiddle
Huaman: Asasmita: high performance book should give you just enough internals
Rumery: ArtisanIndia, you compute the distance from left-joined tables, if any of those get NULL, entire distance will be NULL and the row won’t show anyway, so you could use some inner joins in there
Malgieri: Asasmita: I haven’t read DBA part of it though
Megill: Let me remove group by and see
Shierling: But that increases the number of results Naktibalda
Macewen: ArtisanIndia: that’s what you wanted few minutes ago