MariaDB [cpptest]> describe test2;
+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| key     | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| Column2 | datetime         | NO   |     | NULL    |                |
| Column3 | int(11)          | NO   |     | NULL    |                |
+---------+------------------+------+-----+---------+----------------+
3 rows in set (0.002 sec)

MariaDB [cpptest]> select * from test2;
+-----+---------------------+---------+
| key | Column2             | Column3 |
+-----+---------------------+---------+
|   1 | 2024-12-02 18:59:32 |     350 |
|   2 | 2024-12-02 18:59:38 |      20 |
|   3 | 2024-12-02 18:59:41 |      25 |
|   4 | 2024-12-02 18:59:44 |     550 |
+-----+---------------------+---------+
4 rows in set (0.000 sec)

MariaDB [cpptest]> select key from test2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key from test2' at line 1
MariaDB [cpptest]> describe test;
+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| Column1 | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| Column2 | datetime         | NO   |     | NULL    |                |
| Column3 | int(11)          | NO   |     | NULL    |                |
+---------+------------------+------+-----+---------+----------------+
3 rows in set (0.002 sec)

MariaDB [cpptest]> select * from test;
+---------+---------------------+---------+
| Column1 | Column2             | Column3 |
+---------+---------------------+---------+
|       1 | 2024-12-02 18:33:36 |      15 |
|       2 | 2024-12-02 18:33:58 |      30 |
|       3 | 2024-12-02 18:34:03 |      18 |
|       4 | 2024-12-02 18:34:09 |     350 |
+---------+---------------------+---------+
4 rows in set (0.000 sec)

MariaDB [cpptest]> select Column1 from test;
+---------+
| Column1 |
+---------+
|       1 |
|       2 |
|       3 |
|       4 |
+---------+
4 rows in set (0.000 sec)

MariaDB [cpptest]>