20201022_20 테이블 만들기, 데이터 삽입, 조인

 

 

 

 

INSERT INTO student_info
        (name, phone, email, age, fired)
VALUES ('김재현', '01092046805', 'wogus6804@naver.com', 13, 'N');

INSERT INTO 테이블(컬럼1,컬럼2,...)

VALUES('값1', '값2',...);

 

 

 

 

 

 

 

 

 

SELECT 열1, 열2, ...열N

FROM 테이블_이름

 

 

SELECT name, phone, email, age, fired

FROM student_info;

 

 

이거 왜케 오류가 많이 나 으아아앙

 

 

DROP 

DROP TABLE student_info;
CREATE TABLE student_info (
    name VARCHAR2(128) NOT NULL,
    phone VARCHAR2(128) NOT NULL,
    email VARCHAR2(128) NOT NULL,
    age VARCHAR2(128) NOT NULL,
    fired CHAR(1) default 'N',
    department_id NUMBER
);

SELECT * FROM student_info;

 

 

ㅈ

조건 안걸어서 카타시안곱

 

 

조인하기