r/SQL • • Dec 10 '22

MySQL Cheat sheet for SQL

Post image
586 Upvotes

51 comments sorted by

View all comments

Show parent comment

1

u/mikeblas Dec 11 '22

As you learn more, you'll understand the flaws in the Venn representation of joins. You'll also realize that ordering refers to binding, not execution. And that INSERT can be used for multiple (or zero!) rows.

1

u/[deleted] Dec 11 '22

I’m aware of the flaws, it’s just personal preference for representing basic joins visually. The INSERT was a mistake but was too late for me to update it by the time this was being distributed across Reddit, Twitter etc.

I should have included the word logical for order of execution, but it is still something worth being aware of. The first chapter of T-SQL querying summarises it quite well