강의

멘토링

커뮤니티

Inflearn Community Q&A

ehs0525773698's profile image
ehs0525773698

asked

Non-majors catching up with majors - Database, SQL

SELECT and WHERE

[섹션3] 사원 테이블 데이터 추가하실 분들을 위한 쿼리문

Written on

·

515

·

Edited

3

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('제로초', 'zerocho@gmail.com', '10000', '개발팀', '1');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('원초', 'onecho@gmail.com', '6000', '디자인팀', '1');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('투초', 'twocho@gmail.com', '8000', '기획팀', '1');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('쓰리초', 'threecho@gmail.com', '7000', '기획팀', '2');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('포초', 'fourcho@gmail.com', '9000', '개발팀', '2');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('파이브초', 'fivecho@gmail.com', '6000', '기획팀', '3');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('식스초', 'sixcho@gmail.com', '6000', '개발팀', '3');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('세븐초', 'sevencho@gmail.com', '5000', '개발팀', '4');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('에잇초', 'eightcho@gmail.com', '4000', '디자인팀', '4');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('나인초', 'ninecho@gmail.com', '3000', '개발팀', '4');

INSERT INTO zerocho.`employee` (`name`, email, salary, team, role_id) VALUES ('텐초', 'tencho@gmail.com', '2500', '기획팀', '5');

sqlmysqldbms/rdbmsmysql-workbench

Answer 1

1

zerocho님의 프로필 이미지
zerocho
Instructor

감사합니다! 강의에 올려둘게요

ehs0525773698's profile image
ehs0525773698

asked

Ask a question