반응형
1. SQL:
CREATE TABLE EMPLOYEE (
EMP_ID INT UNSIGNED AUTO_INCREMENT,
EMP_NAME CHAR(100),
JOB CHAR(100),
CITY CHAR(100),
COUNTRY CHAR(100),
PRIMARY KEY(EMP_ID )
)
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('JOHNNY','GUITAR','SEOUL','KOREA');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('JENNY','BASS','SEOUL','KOREA');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('LUCY','ACOUSTIC','WARSAW','POLAND');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('ULA','UKULELE','WARSAW','POLAND');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('ASIA','POWERDRUM','ZAKOPANE','POLAND');
SELECT * FROM EMPLOYEE
2. Files :
반응형