|
Enter password: ************
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.7-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]> show tables;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> use test;
Database changed
MariaDB [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| test |
+----------------+
1 row in set (0.00 sec)
MariaDB [test]> select * from test;
+----+----------------------------------+---------------------+
| ID | Name | Time |
+----+----------------------------------+---------------------+
| 1 | Test | 2015-10-10 12:15:36 |
| 2 | Row 2 | 2015-10-10 12:15:45 |
| 3 | This could be a good chance. | 2015-10-10 12:17:04 |
| 4 | The function is deprecated here. | 2015-10-10 12:17:38 |
+----+----------------------------------+---------------------+
4 rows in set (0.00 sec)
MariaDB [test]> select * from test;
+----+-----------------------------------------------+---------------------+
| ID | Name | Time |
+----+-----------------------------------------------+---------------------+
| 1 | Test | 2015-10-10 12:15:36 |
| 2 | Row 2 | 2015-10-10 12:15:45 |
| 3 | This could be a good chance. | 2015-10-10 12:17:04 |
| 4 | The function is deprecated here. | 2015-10-10 12:17:38 |
| 5 | But those features are currently unavailable. | 2015-10-10 12:19:07 |
+----+-----------------------------------------------+---------------------+
5 rows in set (0.00 sec)
MariaDB [test]>
|
