SQL Exercise (Company Table)

Script (One Table : CREATE, INSERT)
내용 수정 후 Query Input의 'Execute' 선택 하세요.(새로운 내용 작성가능)
CREATE TABLE company (empno VARCHAR(10),name VARCHAR(15), job varchar(20),lono INT(3),stdat date, PRIMARY KEY(empno));
INSERT INTO company (empno,name,job,lono,stdat) VALUES ('2010005','Iron Man',' Manager',1,'2010-03-05'), ('2018113','Black Widow','Staff',3,'2018-3-4'), ('2015027','Spider Man','Assistant manager',1,'2015-6-5'), ('2021005','Batman','Staff',4,'2021-3-4'), ('2005037','Hulk','General Manager',5,'2005-3-7'), ('2015006','Iron Man','Assistant manager',2,'2015-04-09')
Contents
SELECT * FROM company;
empno name job lono stdat
2005037 Hulk General Manager 5 2005-03-07
2010005 Iron Man Manager 1 2010-03-05
2015006 Iron Man Assistant manager 2 2015-04-09
2015027 Spider Man Assistant manager 1 2015-06-05
2018113 Black Widow Staff 3 2018-03-04
2021005 Batman Staff 4 2021-03-04
Query Input
SELECT, INSERT, DELETE, UPDATE, ALTER, DROP명령을 작성 후 'Execute' 선택하세요.
Result
😲 위 Query입력에 명령을 입력 후 'Execute'을 선택해 주세요.
Copyright 2022 © SQL Query