magento、DB確認場所

はじめに

下記、さくナレの記事にて、使用したDBのテーブルの確認場所。

リンクはこちら

最終更新日

2021年8月26日

環境の情報

OS
ubuntu 20.04

実際に

vagrant@ubuntu2004:/var/www/html/magento$ 

mysql -u magento -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 424
Server version: 8.0.26-0ubuntu0.20.04.2 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| magento            |
+--------------------+
5 rows in set (0.03 sec)

mysql> use magento
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

mysql> show tables;
+------------------------------------------------------+
| Tables_in_magento                                    |
+------------------------------------------------------+             
| my_news                                                                                                                                       
+------------------------------------------------------+
410 rows in set (0.08 sec)

mysql> select * from my_news;
+---------+----------+-------------------+---------------------+---------------------+
| news_id | title    | content           | created_at          | updated_at          |
+---------+----------+-------------------+---------------------+---------------------+
|       1 | 記事1    | これは記事1       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       2 | 記事2    | これは記事2       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       3 | 記事3    | これは記事3       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       4 | 記事4    | これは記事4       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       5 | 記事5    | これは記事5       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       6 | 記事6    | これは記事6       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       7 | 記事7    | これは記事7       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       8 | 記事8    | これは記事8       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|       9 | 記事9    | これは記事9       | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
|      10 | 記事10   | これは記事10      | 2021-08-26 03:30:28 | 2021-08-26 03:30:28 |
+---------+----------+-------------------+---------------------+---------------------+
10 rows in set (0.00 sec)