mysql join: 1개의 글
Mysql Join, union, view
출처 : http://rapapa.net/?p=311 ● 샘플 데이타 생성 입력 CREATE TABLE user_info ( id bigint NOT NULL AUTO_INCREMENT COMMENT '고유 번호', name varchar(64) NOT NULL DEFAULT '' COMMENT '이름', reg_date datetime NOT NULL COMMENT '등록 시각', address varchar(64) NOT NULL DEFAULT '' COMMENT '주소', phone varchar(64) NOT NULL DEFAULT '' COMMENT '주소', PRIMARY KEY (id, name) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='테스트 ..
Database/mysql tip
2021. 4. 11. 03:41