Advanced SQL

[kramoo]

Why do we put under from products

Can we not just put products description or something?

[Poppzan]

Great tutorial. These are not that hard to understand, but very powerful to use. Good job :)

[patricks1988]

Nice tutorial, What program is that what you use in this video??

[optikalefxx]

@patricks1988 its called sequelPro

[patricks1988]

@optikalefxx Thanks:D

[AnLa061095]

@optikalefxx Another greate program made by sun is MySql Workbench, downloadable from their site.

Just google MySql Workbench download and click the result that leads to the dev.sun.com page.

[optikalefxx]

@AnLa061095 mysql workbench looks like it was made for mac os 9. Not a fan.

[AnLa061095]

@optikalefxx Another greate program made by sun is MySql Workbench, downloadable from their site.

Just google MySql Workbench download and click the result that leads to the dev.mysql.com page.

[rozalooney]

cool - thanks - I like how you cover it all in one quick example!

[tanasecosminromeo]

Daamn ... I use mysql for a long long time, but I was learning it "on the move" and for this type of things I was using lots and lots and lots of query's and php ... dude you are a life saver

[YouMockMe]

Oh... ok wait till the last minute on the whole LEFT JOIN huh... but I'd still like an answer to the whole INNER and OUTER etc. JOINs.

Thanks again

[optikalefxx]

@YouMockMe haha, sorry about that, i thought i had explained them in the beginning but i guess i didn't.

Joins are complicated, but in general in MySQL (not regular sql) left join does the same as outer join, and then join does the same as inner join. (cross join can be used too)

right join isn't really used, neither is natural joins. Honestly in all the db work i've done, i've never needed more than join and left join.

[YouMockMe]

Thanks for this... I've been wondering why someone would use GROUP BY vs SELECT DISTINCT... you've made it real clear. We appreciate it man.

FYI - What I do is put the "," in front. Makes trouble shooting easy.

Question: What is the difference between JOIN and LEFT JOIN; additionally the INNER, OUTER JOINs etc..?

[warlord90210]

Awesome, extremely useful.

[NeoReloaded00]

Great tutorial. SQL was the second language i learnt years back. 

[shayat123456]

hey, thanks for this tutorials,

Please take it a little bit slower

[optikalefxx]

@shayat123456 No problem, I'm used to the 10 minute time limit.