2 smith smithee 54998 jones jonesse 20 29 jones

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: lt;tab> 2.5 You can insert multiple tuples with one INSERT command: INSERT INTO Students VALUES (53688, ‘Smith’,[email protected], 18, 3.2), Smith’ [email protected] (54998, ‘Jones’, [email protected], 20, 2.9), Jones’ [email protected] (67301, ‘Verner’, [email protected], NULL, 2.5); Verner’ [email protected] Load file into table: LOAD DATA LOCAL INFILE ‘/path/mystudents.txt’ /path/mystudents.txt’ INTO TABLE Students; If text file was created on Windows with editor that uses \r\n as line terminator, add this clause at end of LOAD DATA command: LINES TERMINATED BY ‘\r\n’; 55 55 Exercise 5.1 (pp. 174-175) 56 Exercise 5.8.2 (p. 179) Consider the following relations: Student (snum, sname, major, level, age) (snum sname, Class (name, meets_at, room, fid) (name meets_at, Enrolled (snum, cname) (snum Faculty (fid, fname, deptid) (fid fname, deptid) Write the following queries in SQL. No duplicates should be printed printed in any of the answers. Consider the following relations: Student (snum, sname, major, level, age) (snum...
View Full Document

This note was uploaded on 10/15/2012 for the course CSE 4503 taught by Professor Edallen during the Fall '12 term at Mississippi State.

Ask a homework question - tutors are online