DATABASE2 MySQL - 11.SELECT - egoing

예제 소스

mysql> INSERT INTO topic(title,description,created,author,profile) VALUES ('MySQL','MySQL is ...',NOW(),'egoing','developer');
Query OK, 1 row affected (0.04 sec)

mysql> INSERT INTO topic(title,description,created,author,profile) VALUES ('ORCALE','ORCALE is ...',NOW(),'egoing','developer');
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO topic(title,description,created,author,profile) VALUES ('SQL Server','SQL Server is ...',NOW(),'duru','database administrator');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO topic(title,description,created,author,profile) VALUES ('PostgreSQL','PostgreSQL is ...',NOW(),'taeho','data sicentist, developer');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO topic(title,description,created,author,profile) VALUES ('MongoDB','MongoDB is ...',NOW(),'egoing','developer');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM topic
    -> ;
+----+------------+-------------------+---------------------+--------+---------------------------+
| id | title      | description       | created             | author | profile                   |
+----+------------+-------------------+---------------------+--------+---------------------------+
|  1 | MySQL      | MySQL is ...      | 2021-10-13 19:58:34 | egoing | developer                 |
|  2 | ORCALE     | ORCALE is ...     | 2021-10-13 20:13:20 | egoing | developer                 |
|  3 | SQL Server | SQL Server is ... | 2021-10-13 20:13:28 | duru   | database administrator    |
|  4 | PostgreSQL | PostgreSQL is ... | 2021-10-13 20:13:35 | taeho  | data sicentist, developer |
|  5 | MongoDB    | MongoDB is ...    | 2021-10-13 20:13:40 | egoing | developer                 |
+----+------------+-------------------+---------------------+--------+---------------------------+
5 rows in set (0.00 sec)

예제 소스