Lecture 10 - More SQL - annotated

Lecture 10 - More SQL - annotated - More SQL INFO/COM S...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 More SQL INFO/COM S 230: Intermediate Web Design and Programming Common problems with P2 • Code didn’t work • Search functionality crippled (e.g. only search on two attributes) • Navigation (no way to return to home page from search results) • Error checking issues • Design issues • Late Resources • We give two weeks for projects; start early! • Office hours – Hard to do debugging in online office hours; start early! – If you need other times, let me know • Forums A brief review of SQL Recall the basic form of an SQL statement: SELECT attributes FROM relation(s) WHERE condition; E.g. SELECT Name, Title FROM Movies WHERE LENGTH > 150; 201 mins. 2003 The Return of the King 113 mins. 2002 Chicago 2004 2001 2000 Year Length Title 132 mins. Million Dollar Baby 135 mins. A Beautiful Mind 155 mins. Gladiator Easy PDF Creator is professional software to create PDF. If you wish to remove this line, buy it now.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Joins We can also do joins. SELECT m.Title, m.Year, Name FROM Movies m, StarsIn s WHERE m.Title = s.Title AND m.Year = s.Year; 201 mins. 2003 The Return of the King 113 mins. 2002 Chicago 2004 2001 2000 Year Length Title 132 mins. Million Dollar Baby 135 mins. A Beautiful Mind 155 mins. Gladiator Year Title Name 2004 Million Dollar Baby Hillary Swank 2003 Return of the King Viggo Mortensen 2001 A Beautiful Mind Russel Crowe 2000 Gladiator Russel Crowe Joins And natural joins. . SELECT Title, Year, Name
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Lecture 10 - More SQL - annotated - More SQL INFO/COM S...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online