코리아IT핀테크과정

MySQL 설치

언제나즐거운IT 2024. 3. 10. 15:46

https://blog.naver.com/coding_helper/222632830115

 

MySQL을 시작해보자. 설치편

[1] MySQL을 설치하기위해 우선 다운로드를 수행한다. [2] MySQL을 설치한다. 설치중에 발생한 모...

blog.naver.com

https://blog.naver.com/coding_helper/222632837868

 

MySQL을 시작해보자. 설정편

1. password 1234 입력 2. show databases; 현재 기본 db들이 나오고있음을 확인할 수 있다. 3. kimdb를 생...

blog.naver.com

 

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| kimdb              |
| mysql              |
| performance_schema |
| spring             |
| sys                |
+--------------------+
6 rows in set (0.00 sec)

mysql> USE KIMDB;
Database changed
mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> CREATE TABLE MEMBER(
    -> MID VARCHAR(10) PRIMARY KEY,
    -> PASSWORD VARCHAR(10) NOT NULL,
    -> NAME VARCHAR(20) NOT NULL,
    -> ROLE VARCHAR(10) NOT NULL
    -> );
Query OK, 0 rows affected (0.02 sec)

mysql> SHOW TABLES;
+-----------------+
| Tables_in_kimdb |
+-----------------+
| member          |
+-----------------+
1 row in set (0.00 sec)

mysql> CREATE TABLE BOARD(
    -> BID INT PRIMARY KEY AUTO_INCREMENT,\
    ->
    -> _'
    '>
    '> );;
    '>
    '>
    '> ;
    '> ;;
    '> EXIT
    '>
    '> ^C
mysql> ^C
mysql> ^C
mysql>
mysql>
mysql>
mysql> CREATE TABLE BOARD(
    -> BID INT PRIMARY KEY AUTO_INCREMENT,
    -> TITLE VARCHAR(30) NOT NULL,
    -> CONTENT VARCHAR(30) NOT NULL,
    -> WRITER VARCHAR(10) NOT NULL
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO MEMBER VALUES('
    '> ^X^C
mysql> ^C
mysql> INSERT INTO MEMBER VALUES('test','1234','테스트','USER');
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO MEMBER VALUES('admin','1234','관리자','ADMIN');
Query OK, 1 row affected (0.00 sec)

mysql> SHOW TABLES;
+-----------------+
| Tables_in_kimdb |
+-----------------+
| board           |
| member          |
+-----------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM MEMBER;
+-------+----------+--------+-------+
| MID   | PASSWORD | NAME   | ROLE  |
+-------+----------+--------+-------+
| admin | 1234     | 관리자 | ADMIN |
| test  | 1234     | 테스트 | USER  |
+-------+----------+--------+-------+
2 rows in set (0.00 sec)

mysql> INSERT INTO BOARD VALUES(1001,'제목','내용','test');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO BOARD (TITLE,CONTENT,WRITER) VALUES('제목22','내용22','test');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM BOARD;
+------+--------+---------+--------+
| BID  | TITLE  | CONTENT | WRITER |
+------+--------+---------+--------+
| 1001 | 제목   | 내용    | test   |
| 1002 | 제목22 | 내용22  | test   |
+------+--------+---------+--------+
2 rows in set (0.00 sec)

mysql>