Ch05_GCSdata_MySQL.txt - Database Systems Coronel\/Morris Type of SQL MySQL CREATE TABLE CUSTOMER CUS_ID int CUS_NAME varchar(50 CUS_PHONE varchar(50

Ch05_GCSdata_MySQL.txt - Database Systems Coronel/Morris...

This preview shows page 1 - 2 out of 2 pages.

/* Database Systems, Coronel/Morris */ /* Type of SQL : MySQL */ CREATE TABLE CUSTOMER ( CUS_ID int, CUS_NAME varchar(50), CUS_PHONE varchar(50), REGION_ID int ); INSERT INTO CUSTOMER VALUES('1','See Rocks','678-257-2857','1'); INSERT INTO CUSTOMER VALUES('2','Bellsouth','931-685-1563','2'); INSERT INTO CUSTOMER VALUES('3','AT&T','615-725-7896','3'); INSERT INTO CUSTOMER VALUES('4','ClearChannel','423-596-6241','4'); INSERT INTO CUSTOMER VALUES('5','Comcast','901-895-5547','5'); INSERT INTO CUSTOMER VALUES('6','Enron','865-489-3699','6'); /* -- */ CREATE TABLE EMPLOYEE ( EMP_ID int, EMP_LNAME varchar(50), EMP_INITIAL varchar(50), EMP_FNAME varchar(50), EMP_HIREDATE datetime, REGION_ID int ); INSERT INTO EMPLOYEE VALUES('1','Seaton','M','Amy','2001-2-7','1'); INSERT INTO EMPLOYEE VALUES('2','Craig','M','Brett','2000-8-16','3'); INSERT INTO EMPLOYEE VALUES('3','Sewell','Z','Beth','2000-9-15','4'); INSERT INTO EMPLOYEE VALUES('4','Williams','R','Josh','2000-4-7','2'); INSERT INTO EMPLOYEE VALUES('5','Chandler','E','Joseph','2001-6-12','5'); INSERT INTO EMPLOYEE VALUES('6','Robbins','E','Erin','2001-8-25','6'); INSERT INTO EMPLOYEE VALUES('7','Burklow','C','Shan','2000-11-26','1'); INSERT INTO EMPLOYEE VALUES('8','Yarbrough','B','Peter','2001-1-9','6');
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '19
  • INSERT, TABLE Employee, customer values

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture