MariaDB

[yamanoi@sakura public_hhtml ] $ mysql -u u1941000 -p
Enter password:パスワード
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6896
Server version: 10.4.18-MariaDB MariaDB Server

Copyright (c) 2000, 2018, 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 |
| sakura |
| u1941000 |
+——————–+
3 rows in set (0.014 sec)

MariaDB [(none)]> use u1941000;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [u1941000]> show tables;
+——————–+
| Tables_in_u1941000 |
+——————–+
| tbl_ehon |
+——————–+
1 row in set (0.000 sec)

MariaDB [u1941000]> select * from tbl_ehon;
+—-+—————–+——-+
| id | title | price |
+—-+—————–+——-+
| 1 | Cの絵本 | 1380 |
| 2 | TCP/IPの絵本 | 1580 |
| 3 | SQLの絵本 | 1680 |
| 4 | Perlの絵本 | 1680 |
+—-+—————–+——-+
4 rows in set (0.000 sec)

MariaDB [u1941000]> quit;
Bye

カテゴリー: Linux, 仕事 タグ: , , パーマリンク