Answer the question
In order to leave comments, you need to log in
JOIN ... USING or JOIN ... ON?
Hello!
Tell me please. is there any performance/security difference between these three examples:
SELECT * FROM table1, table2 WHERE table1.id = $id AND table1.id=table2.id
SELECT * FROM table1 LEFT JOIN table2 ON (table1.id = table2. id) WHERE table1.id = $id
SELECT * FROM table1 LEFT JOIN table2 USING (id) WHERE table1.id = $id
Answer the question
In order to leave comments, you need to log in
Aleksey Ukolov correctly wrote, with the only difference that the first query is essentially an INNER JOIN, when the second and third LEFT JOINs are
at the expense of the speed of the first one, and if the query is presented as an INNER JOIN, I would argue that in my opinion the speed will be identical
My version without flex
https://codepen.io/ArtemVedischev/pen/jYxGdq
PS Pay attention to the styles when hovering over the menu item (li) without hovering over the link, the background changed color, but the link did not.
.menu_gallery li a:hover {
color: #fff;
}
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question