[SQL] table 생성

TABLE CREATE

1. CREATE TABLE; -> INSERT INTO;
2. Source TABLE -> CREATE (SELECT FROM );

1. insert into로 데이터 삽입

-- OBject (Text) Type 
CREATE TABLE hr.hr_cate 
(
	EmployeeNumber int(11)
  , Attrition VARBINARY(50)
  , BusinessTravel VARBINARY(50)
  , Department VARBINARY(50)
  , EducationField VARBINARY(50)
  , Gender VARBINARY(50)
  , JobRole VARBINARY(50)
  , MaritalStatus VARBINARY(50)
  , OverTime VARBINARY(50)
);


INSERT INTO hr.hr_cate 
(
	SELECT 	EmployeeNumber
	  , Attrition
	  , BusinessTravel
	  , Department
	  , EducationField
	  , Gender
	  , JobRole
	  , MaritalStatus 
	  , OverTime 
	FROM hr_employee_attrition hea
)
;

2. 원본(source) 테이블을 이용해서 새로운 테이블을 생성

-- 2. Numeric Table
CREATE TABLE hr.hr_number
(SELECT 
EmployeeNumber, Age,DailyRate,DistanceFromHome
,Education,EmployeeCount,EnvironmentSatisfaction
,HourlyRate,JobInvolvement,JobLevel,JobSatisfaction,MonthlyIncome
,MonthlyRate,NumCompaniesWorked,PercentSalaryHike,PerformanceRating,RelationshipSatisfaction
,StandardHours,StockOptionLevel,TotalWorkingYears,TrainingTimesLastYear,WorkLifeBalance
,YearsAtCompany,YearsInCurrentRole,YearsSinceLastPromotion,YearsWithCurrManager
FROM hr.hr_employee_attrition hea 
)
;