[MySQL] ERD 수강관리프로그램 2. 내부 데이터 삽입

< 데이터 삽입시 foreign key의 값이 다른경우 삽입X >

1. student 테이블 데이터 삽입

insert into student values (), (), () ; 

mysql> insert into student values
    -> ('2019160123','정봉준','컴퓨터공학과',2,64),
    -> ('2019456001','강길동','디자인',3,60),
    -> ('2020123001','강나래','화학공학',1,21),
    -> ('2020123020','박철수','화학공학',1,20),
    -> ('2020160001','강철수','컴퓨터공학',1,20),
    -> ('2020160002','나영희','컴퓨터공학',1,19);
Query OK, 6 rows affected (0.01 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> select * from student;
+------------+----------+--------------+----------+-----------+
| std_num    | std_name | std_major    | std_term | std_point |
+------------+----------+--------------+----------+-----------+
| 2019160123 | 정봉준   | 컴퓨터공학과 |        2 |        64 |
| 2019456001 | 강길동   | 디자인       |        3 |        60 |
| 2020123001 | 강나래   | 화학공학     |        1 |        21 |
| 2020123020 | 박철수   | 화학공학     |        1 |        20 |
| 2020160001 | 강철수   | 컴퓨터공학   |        1 |        20 |
| 2020160002 | 나영희   | 컴퓨터공학   |        1 |        19 |
+------------+----------+--------------+----------+-----------+
6 rows in set (0.00 sec)

2. course 테이블 데이터 삽입

mysql> insert into course values
    -> ('20201ipc001','컴퓨터개론','유관순',2,2,'화1A,1B,2A,2B'),
    -> ('20202ipc002','기초전기', '이순신', 3,4,'월1A,1B,2A,목1A,1B,2A'),
    -> ('20201msc001','대학수학기초','홍길동',3,3,'월1A,1B,2A,수1A,1B,2A'),
    -> ('20202msc002','프로그래밍일반','임꺽정',3,3,'월1A,1B,2A목1A,1B,2A');
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from course;
+-------------+----------------+--------------+----------+---------+-----------------------+
| co_code     | co_name        | co_professor | co_point | co_time | co_timetable          |
+-------------+----------------+--------------+----------+---------+-----------------------+
| 20201ipc001 | 컴퓨터개론     | 유관순       |        2 |       2 | 화1A,1B,2A,2B         |
| 20201msc001 | 대학수학기초   | 홍길동       |        3 |       3 | 월1A,1B,2A,수1A,1B,2A |
| 20202ipc002 | 기초전기       | 이순신       |        3 |       4 | 월1A,1B,2A,목1A,1B,2A |
| 20202msc002 | 프로그래밍일반 | 임꺽정       |        3 |       3 | 월1A,1B,2A목1A,1B,2A  |
+-------------+----------------+--------------+----------+---------+-----------------------+
4 rows in set (0.00 sec)

3. attend 테이블 데이터 삽입

mysql> insert into attend(at_std_num, at_co_code) values
    -> ('2020160001','20201msc001'),
    -> ('2020160002','20201msc001'),
    -> ('2019160123','20202msc002'),
    -> ('2019456001','20202msc002'),
    -> ('2020123001','20201ipc001'),
    -> ('2020123020','20201ipc001'),
    -> ('2019456001','20202ipc002'),
    -> ('2019160123','20202ipc002'),
    -> ('2020160001','20202msc002'),
    -> ('2020160002','20202msc002'),
    -> ('2019160123','20201msc001'),
    -> ('2019456001','20201msc001'),
    -> ('2020123001','20201msc001'),
    -> ('2020123020','20201msc001'),
    -> ('2019456001','20202msc002'),
    -> ('2019160123','20202msc002');
Query OK, 16 rows affected (0.00 sec)
Records: 16  Duplicates: 0  Warnings: 0

mysql> select * from attend;
+--------+------------+-------------+---------+---------+--------+----------+-----------+-------+---------------+----------+
| at_num | at_std_num | at_co_code  | at_year | at_term | at_mid | at_final | at_attend | at_hw | at_repetition | at_score |
+--------+------------+-------------+---------+---------+--------+----------+-----------+-------+---------------+----------+
|     81 | 2020160001 | 20201msc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     82 | 2020160002 | 20201msc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     83 | 2019160123 | 20202msc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     84 | 2019456001 | 20202msc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     85 | 2020123001 | 20201ipc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     86 | 2020123020 | 20201ipc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     87 | 2019456001 | 20202ipc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     88 | 2019160123 | 20202ipc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     89 | 2020160001 | 20202msc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     90 | 2020160002 | 20202msc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     91 | 2019160123 | 20201msc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     92 | 2019456001 | 20201msc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     93 | 2020123001 | 20201msc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     94 | 2020123020 | 20201msc001 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     95 | 2019456001 | 20202msc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
|     96 | 2019160123 | 20202msc002 |    NULL |    NULL |      0 |        0 |         0 |     0 | n             | NULL     |
+--------+------------+-------------+---------+---------+--------+----------+-----------+-------+---------------+----------+
16 rows in set (0.00 sec)