SQL3 - CS105 Lab 4 Functions, Advanced Join, Insert/Delete...

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

View Full Document Right Arrow Icon
CS105 - Spring 2008 1 CS105 Lab 4 – Functions, Advanced Join,  Insert/Delete Records, Create Table Announcements: MP2 is posted online and is now due on  Sunday, February  17 th  at noon .   Midterm 1 is on  Tuesday, February 19 th  at 7:00pm   (Additional information will be posted soon on the course  website).  If you need to take the conflict exam, request a  conflict from the conflict request page absolutely no later  than  Thursday, February 14 th . If you need help finding someone to work with on the next  MP, send an email to Lin ( lin36@uiuc.edu )
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 Connecting with SQLyog Start SQLyog.  (Start / Class Software /  CS105 / SQLyog) You should see login screen. If  a connection is not already defined,  click “New” and name the new  connection CS105. Enter the following data into the login  screen: Hostname:  cs105-mysql1.cs.uiuc.edu  or cs105-mysql2.cs.uiuc.edu  User:  cs105 Password:  cs105 Leave the ‘Database(s)’ box blank. Click “Connect!”
Background image of page 2
CS 105 – Spring 2008 3 Objectives Use advanced joins to look at data from  multiple tables Insert and delete records in SQL, alter a  table Create a table If time, review functions in SQL Review an Alias field in a record set 
Background image of page 3

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

View Full DocumentRight Arrow Icon
CS105 - Spring 2008 4 Advanced Joins Sometimes, you want to join more than two tables to  get the data you need.  For example, from the  TeachYourself  database, list  all product names that were purchased during the  month of January. The data you need is found in 3 different tables!  They can be connected based on common fields  between the table, like the order number and  product id.
Background image of page 4
CS105 - Spring 2008 Month Function To find dates in January, we will use the  MONTH function, which returns a number  between 1 and 12.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 24

SQL3 - CS105 Lab 4 Functions, Advanced Join, Insert/Delete...

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

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