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

Sandoz: Http://pastebin.pl/view/48436b6e

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