SQL Exercise (School Table)

Script (One Table : CREATE, INSERT)
내용 수정 후 Query Input의 'Execute' 선택 하세요.(새로운 내용 작성가능)
CREATE TABLE school (stdnum VARCHAR(15),name VARCHAR(15), birth DATE,eng INT(3),mat INT(3), PRIMARY KEY(stdnum));
INSERT INTO school (stdnum,name,birth,eng,mat) VALUES ('20210110','Iron Man','1970-5-29',95,30), ('20200207','Black Widow','1984-12-3',100,NULL), ('20190522','Spider Man','2001-8-10',99,55), ('20201007','Batman','1915-4-17',100,80), ('20211201','Hulk','1969-12-18',80,75), ('20203027','Batman','2001-7-5',95,95);
Contents
SELECT * FROM school;
stdnum name birth eng mat
20190522 Spider Man 2001-08-10 99 55
20200207 Black Widow 1984-12-03 100
20201007 Batman 1915-04-17 100 80
20203027 Batman 2001-07-05 95 95
20210110 Iron Man 1970-05-29 95 30
20211201 Hulk 1969-12-18 80 75
Query Input
SELECT, INSERT, DELETE, UPDATE, ALTER, DROP명령을 작성 후 'Execute' 선택하세요.
Result
😲 위 Query입력에 명령을 입력 후 'Execute'을 선택해 주세요.
Copyright 2022 © SQL Query