쿠카의 개발일지

[교재 SQL 스크립트] 실전_ch1-2-1-member_info.sql use mydb;CREATE TABLE member_info ( member_no INT, name VARCHAR(10), gender VARCHAR(1));INSERT INTO member_infoVALUES (10, '이장현', 'M');INSERT INTO member_infoVALUES (20, '유길채', 'F');INSERT INTO member_infoVALUES (30, '남연준', 'M');INSERT INTO member_infoVALUES (40, '경은애', 'F');INSERT INTO member_infoVALUES (50, '량음', 'M');COMMIT;SELECT name, ..

[교재 SQL 스크립트] 실전_ch1-1-3-departments&employees.sqlUSE mydb;CREATE TABLE departments( department_id INT, department_name VARCHAR(30));CREATE TABLE employees( employee_id INT, employee_name VARCHAR(20), salary INT, department_id INT);INSERT INTO departmentsVALUES (10, '데이터분석팀');INSERT INTO departmentsVALUES (20, 'DB기술팀');INSERT INTO departmentsVALUES (30, '클라우드팀');INSERT INTO dep..

[교재 SQL 스크립트] 실전_ch1-1-2-product&payment.sqlUSE mydb;CREATE TABLE product( product_no VARCHAR(4), product_name VARCHAR(20), price INT);CREATE TABLE payment ( payment_no VARCHAR(8), member_id VARCHAR(10), product_no VARCHAR(4));INSERT INTO productVALUES ('S100', '미니선풍기', 3500);INSERT INTO productVALUES ('S101', '행운목', 2000);INSERT INTO productVALUES ('S102', '야광텀블러', 6500);INSER..

[교재 SQL 스크립트] 실전_ch1-1-1-student&winner_list.sqlUSE mydb;create table if not exists mydb.student( id varchar(20) null, name varchar(15) null, mobile varchar(11) null)insert into student (id, name, mobile)values ('apple', '김사과', '01011110000');create table if not exists mydb.winner_list( ranking int null, id varchar(20) null)insert into winner_list (ranking, id)v..