IST
MMLab4-SQL-Intro.docx

Null los angeles usa 904 422 9194 1 insert the

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

Null Los Angeles, USA 904-422-9194 1 Insert the following information for grading purposes: 1. Using the SQL tab, enter: show create table people; 2. Click the +Options link and select “Full Texts” and then click the “Go” button 3. Copy/paste the results below:
Image of page 1

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

CREATE TABLE `people` ( `Name` varchar(50) NOT NULL, `Occupation` varchar(100) NOT NULL, `Location` varchar(30) NOT NULL, `Phone` Bigint(11) NOT NULL, `SalaryBracket` int(11) NOT NULL ) Phase 3 – INSERT DATA Step 1 – Create 7 INSERT statements to move all of this data into the table you have just created. For additional practice, create 3 of these INSERT statements with explicit declarations of columns the data is to go into, and for 4 of these INSERT statements, insert the data without explicit declarations. 1. Insert into People (Name, Occupation, Location, Phone, SalaryBracket) Values("Bobby Bottleservice", "Ghost bouncer/professional wedding planning service", "New Jersey, USA",844-555-6969, 4 ); 2. Insert into People (Name, Occupation, Location, Phone, SalaryBracket) Values("Gil Faizon", "Actor/Bachelor", "New York, USA", 42, 2); 3. Insert into People (Name, Occupation, Location, Phone, SalaryBracket) Values("George St. Geegland", "Bachelor/Actor", "New York, USA", 43, 2); 4. Insert into People Values("Dr. Armond", "Pet Plastic Surgeon", "Los Angeles, USA", 904-582- 9876, 5); 5. Insert into People Values("Coach Teacher/Gene Creemers", "Coach/Teacher", "Ontario, CA", 11- 420-499-1048, 3); 6.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '08
  • MCCONN,CHARLOTTERYOO,JUNGWOO
  • Foreign key

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern