SQL2 - CS 105 Spring 2008 1 CS105 Lab 3 Wildcards...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: CS 105 Spring 2008 1 CS105 Lab 3 Wildcards & Functions Announcements: MP1 is available and is due on Saturday, February 2 nd at noon. You are NOT allowed to work in groups for MP1. Each person should complete and submit their own MP1. MP1 FAQ SQL FAQ CS 105 Spring 2008 2 Objectives Learn logical operator precedence order Learn how to use wildcard for template based filtering Study relational operators Query data from two tables CS 105 Spring 2008 3 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! CS 105 Spring 2008 4 Using AND & OR Together Suppose we want to find all Sox players whose first names are either Kevin" or "Jim"? Try this example: select * from players where firstname = Kevin" or firstname = "Jim" and team = "Sox" Is this correct? CS 105 Spring 2008 5 Operator Precedence In SQL, And has a higher priority than Or ....
View Full Document

Page1 / 18

SQL2 - CS 105 Spring 2008 1 CS105 Lab 3 Wildcards...

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