IT Software Developer

DROP TABLE IF EXISTS TEST.Sailors ; DELIMITER // CREATE TABLE Sailors ( sid int(4) NOT NULL, sname varchar(20) NOT NULL, rating int(4) DEFAULT NULL, age float DEFAULT NULL, PRIMARY KEY (sid) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2020년 63번' // INSERT INTO Sailors (sid,sname,rating,age) VALUES (22, 'Dustin', 7, 45.0), (29, 'Brutus', 1, 33.0), (31, 'Lubber', 8, 55.5), (32, 'Andy', 8, 25.5)..

DROP TABLE IF EXISTS TEST.EMP_62 ; DELIMITER // CREATE TABLE EMP_62 ( EMP varchar(50) NOT NULL, ENAME varchar(20) NOT NULL, SEX varchar(2) DEFAULT NULL, SALARY int(10) DEFAULT NULL, DEPT_NO varchar(10) DEFAULT NULL, PRIMARY KEY (EMP) ) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='2020년 60번' // INSERT INTO EMP_62 (EMP,ENAME,SEX,SALARY,DEPT_NO) VALUES ('2020-001', '홍길동', '남', 3000, 2), ('2019-001'..