File: sep6.txt Author: Jeff Kinne Contents: plan/notes for the day Next time - #5. HW3 answers HW4 - inserting/creating, installing MySQL, security, blog/etc. search - look through book for something later on you think is cool... Questions for next time * why WITH and not just in FROM? - answer: could do either way, WITH is there as a convenience to make the queries easier to understand * difference between INNER and NATURAL JOIN? - NATURAL is a type of INNER or OUTER join, which basically has an implicit predicate (all columns with same names) - INNER only gives rows with a match, OUTER puts in nulls when there is not a match. BNF for SQL - http://savage.net.au/SQL/ Example - getting some data into SQL with php or python ...