• 목록

테이블 table_01 table_02 JOIN을 통한 VIEW

table_01 테이블 만들기

CREATE TABLE table_01( 

    id INT(11) NOT NULL AUTO_INCREMENT,

    title VARCHAR(100) NOT NULL,

    info TEXT NULL,

    date DATETIME NOT NULL,

    author VARCHAR(20) NULL,

    amugurna VARCHAR(200) NULL,

    PRIMARY KEY(id)

    );

desc table_01;

테이블 데이터 입력

INSERT INTO table_01(title,info,date,author,profile) VALUES('raspberry','slow slow',NOW(),'tiger','it engineer'); 

INSERT INTO table_01(title,info,date,author,profile) VALUES('raspberry','fast fast',NOW(),'fox','web'); 

INSERT INTO table_01(title,info,date,author,profile) VALUES('raspberry','slow fast',NOW(),'tiger','engineer'); 

select * from table_01;

table_02

CREATE TABLE table_02( 

    id INT(11) NOT NULL AUTO_INCREMENT,

    name VARCHAR(100) NOT NULL,

    amugurna VARCHAR(200) NULL,

    PRIMARY KEY(id)

    );

desc table_02;

table_02 데이터 넣기

INSERT INTO table_01(name, amugruna) VALUES('ray','we are the world');  

테이블 JOIN VIEW

SELECT * FROM table_01 LEFT JOIN table_02 ON table_01.id=table_02.id; 

지정한 table VIEW

SELECT table_01.id, title,info,date,name  FROM table_01 LEFT JOIN table_02 ON table_01.id=table_02.id;