maria db

CLI 로 실행

 SHOW DATABASES;

 +--------------------+
| Database           |
+--------------------+
| information_schema |
| myboard            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

MariaDB [(none)]> USE MYBOARD
MariaDB [MYBOARD]> CREATE TABLE LISTS 
  (
  	NUM INT(11) NOT NULL AUTO_INCREMENT,
    WRITER VARCHAR(20) NOT NULL,
    TITLE VARCHAR(100) NOT NULL,
    CONTENTS VARCHAR(500) NOT NULL,
    INSERT_DATE DATETIME DEFAULT CURRENT_TIMESTAMP()
  );
  MariaDB [MYBOARD]> EXPLAIN LISTS;
+-------------+--------------+------+-----+---------------------+----------------+
| Field       | Type         | Null | Key | Default             | Extra          |
+-------------+--------------+------+-----+---------------------+----------------+
| NUM         | int(11)      | NO   | PRI | NULL                | auto_increment |
| WRITER      | varchar(20)  | NO   |     | NULL                |                |
| TITLE       | varchar(100) | NO   |     | NULL                |                |
| CONTENTS    | varchar(500) | NO   |     | NULL                |                |
| INSERT_DATE | datetime     | NO   |     | current_timestamp() |                |
+-------------+--------------+------+-----+---------------------+----------------+

MariaDB [MYBOARD]> INSERT INTO LISTS (WRITER, TITLE, CONTENTS) VALUES('donnie','게시판을 만들겠습니다.','해보자고!!');

MariaDB [MYBOARD]> SELECT * FROM LISTS;
+-----+--------+------------------------+------------+---------------------+
| NUM | WRITER | TITLE                  | CONTENTS   | INSERT_DATE         |
+-----+--------+------------------------+------------+---------------------+
|   1 | donnie | 게시판을 만들겠습니다. | 해보자고!! | 2022-12-15 16:25:21 |
+-----+--------+------------------------+------------+---------------------+
1 row in set (0.000 sec)