16 MySQL Tutorial for Beginners: Explicit vs Implicit Syntax
When you use the implicit syntax for an inner join, you code the tables in the FROM clause separated by commas.
Then, you code the join conditions in the WHERE clause.
Note that the comparison is coded as the search condition of the WHERE clause.
The implicit syntax was widely used before the introduction of the explicit syntax.
Because the explicit syntax for joins lets you separate join conditions from search conditions, it’s typically easier to read.
We therefore recommend that you use the explicit syntax in all your SQL code.
EXERCISES for your SELF-TRAINING:
http://golearnfast.com/Quizzes.php?_S...
SCRIPT FOR THE EXAMPLES:
http://www.golearnfast.com/files/less...
SUBSCRIBE!
/ @golearnfast
FACEBOOK
/ golearnfast
GOOGLE+
https://plus.google.com/u/0/b/1013263...
On this page of the site you can watch the video online 16 MySQL Tutorial for Beginners: Explicit vs Implicit Syntax with a duration of hours minute second in good quality, which was uploaded by the user golearnfast 09 April 2016, share the link with friends and acquaintances, this video has already been watched 5,229 times on youtube and it was liked by 55 viewers. Enjoy your viewing!
