Apipong Pingyod's Site



Lab 03 SQL Statements- Import from CSV file ??? 1 ??????????????????????????????? 4 ????? ????????????????????????????????? MySQL Monitor ????????????. ????????????????????????1.1 ?????????????????? Employee (2 pts)Hint: ????????? CREATE DATABASE db_name ??? USE db_name;??????? (??? Capture ??????????????????????????)1.2 ????????????????? 4 ????? ???????????????????????????????????? (4 pts)Table1 Definition – EmployeeField nameData TypeDomain valuesemployeeIDINTNOT NULL, Auto_Increment, Primary Key nameVarchar (80)jobVarchar (30)SalaryINTdepartmentIDINTNOT NULLTable2 Definition – DepartmentField nameData TypeDomain valuesdepartmentIDINTNOT NULL, Primary Key nameVarchar (30)Table3 Definition – ClientField nameData TypeDomain valuesclienttIDINTNOT NULL, Auto_Increment, Primary Key nameVarchar (40)addressVarchar (100)contactPersonVarchar (80)contactNumberChar (10)Table4 Definition – AssignmentField nameData TypeDomain valuesclienttIDINTNOT NULLemployeeIDINTworkdateDATEhoursFLOATNote: ???????? clientID, employeeID, ??? workdate ???? Primary Key ???? ????????????Primary key(clientID, employeeID, ??? workdate)?????????????????????????????????????????Hint: ????????????????mysql> CREATE TABLE tbl_name (fieldname1 type [NOT NULL Auto_Increment PRIMARY KEY],fieldname2 type [NOT NULL],fieldname3 type [NOT NULL]);??????????????????????????? mysql>DESCRIBE tbl_name;??????????????????????????????????????????? mysql>SHOW TABLES;??????? (??? Capture ???????????????????????????????????????????? DESCRIBE ???????? ? ????? ????????????????????????????????????????? SHOW TABLES)??? 2 ?????????????????????? Import ??????? Excel (.CSV) ??????? Capture ???????????????????????????????????? (14 Points)** ???????????????????? D:\mysql\Employee ???????????????????????????? ????????? Excel ????????????????????? employee ???????????? SEQ ?????? \* ARABIC 1 ????????????? Employee** ???????????????? employeeID ???????????????? Auto Increment ??????????????? Save ???????? employee ???????? .CSV ???????????? File> Save As > Save as type: CSV????? Import ???? ??????????????????mysql> load data local infile ‘D:\\mysql\\Employee\\employee.csv’ into table employee-> fields terminated by ‘,’-> lines terminated by ‘\n’-> ignore 2 lines (name, job, salary, departmentID);??????? (??? Capture ???????????????????????????????????????????? SELECT * ?????)????????? Excel ????????????????????? department ???????????? 2 ????????????? department??????? Save ???????? department ???????? .CSV ???????????? File> Save As > Save as type: CSV????? Import ???? ??????????????????mysql> load data local infile ‘D:\\mysql\\Employee\\department.csv’ into table department-> fields terminated by ‘,’-> lines terminated by ‘\n’-> ignore 2 lines (departmentID, name);Q1. ??????? (??? Capture ???????????????????????????????????????????? SELECT * ?????)Q2. ???????????????? departmentID ??????? 130 (??? Capture ?????????????????????????????????????????)????????? Excel ????????????????????? client ???????????? 3 ????????????? client** ???????????????? clientID ???????????????? Auto Increment ??????????????? Save ???????? client ???????? .CSV ???????????? File> Save As > Save as type: CSV????? Import ???? ???????????????????????? 2.1) ??? 2.2)Q1. ??????? (??? Capture ???????????????????????????????????????????? SELECT * ?????)Q2. ??????????????????????????????????????????? Imperial Industry (??? Capture ?????????????????????????????????????????) ????????? Excel ????????????????????? assignment ???????????? SEQ ?????? \* ARABIC 4 ????????????? assignmentSave ???????? assigment ???????? .CSV ???????????? File> Save As >Save as type: CSV????? Import ???? ???????????????????????? 2.1) ??? 2.2)Q1. ??????? (??? Capture ???????????????????????????????????????????? SELECT * ?????)Q2. ????????????? ??????????????????????? ????????????????? 1 ?????????????????????????? (??? Capture ?????????????????????????????????????????)**** ???????????????????????????? ??????????????????????????????????????? ****1) ????????????????????????????????? ???????????????????????????????? BS312_Lab03_??????. ???????????????? .pdf2) ??????? .pdf ??????????? apipong.ping@ ???????????????????????????????????? ?????????????????????????? ??????????????????????????????? 3) ??????????????????????? ? ????????????? ????????????????????? ???????????????????????????????????????? 31 ??.?. 2559 ??????????? 24.00 ?. ???????????? Server ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download