1. 목적

2. 테이블 생성

MariaDB [surveydb]> CREATE TABLE USER_INFO ( ID INT PRIMARY KEY AUTO_INCREMENT, USER_NAME VARCHAR(30) NOT NULL, REG_DT DATETIME NOT NULL, STATUS BOOLEAN NOT NULL DEFAULT 1 );
Query OK, 0 ROWS affected (0.018 sec)

 3. 테이블에 데이터 입력

MariaDB [surveydb]> INSERT INTO USER_INFO ( USER_NAME, REG_DT ) VALUES ( 'osstech', CONVERT('2019-09-04 00:10:00',datetime) );
Query OK, 1 ROW affected (0.011 sec)

MariaDB [surveydb]> SELECT * FROM USER_INFO;
+----+-----------+---------------------+--------+
| ID | USER_NAME | REG_DT              | STATUS |
+----+-----------+---------------------+--------+
|  1 | osstech   | 2019-09-04 00:10:00 |      1 |
+----+-----------+---------------------+--------+
1 ROW IN SET (0.007 sec)

MariaDB [surveydb]> INSERT INTO USER_INFO ( USER_NAME, REG_DT ) VALUES ( 'kimdubi', CONVERT('2019-09-04 00:15:00',datetime) );
Query OK, 1 ROW affected (0.011 sec)

MariaDB [surveydb]> SELECT * FROM USER_INFO;
+----+-----------+---------------------+--------+
| ID | USER_NAME | REG_DT              | STATUS |
+----+-----------+---------------------+--------+
|  1 | osstech   | 2019-09-04 00:10:00 |      1 |
|  2 | kimdubi   | 2019-09-04 00:15:00 |      1 |
+----+-----------+---------------------+--------+
2 ROWS IN SET (0.008 sec)