DB レコード調査

[BBCapMegane]

DB レコード調査

Originally posted by @BBCapMegane in https://github.com/IkezoeMakoto/oyster-warrior-2019/issues/1#issuecomment-529162964

[BBCapMegane]

mysql> show tables;
+-----------------------+
| Tables_in_isucari     |
+-----------------------+
| categories            |
| configs               |
| items                 |
| shippings             |
| transaction_evidences |
| users                 |
+-----------------------+
6 rows in set (0.00 sec)

[BBCapMegane]

mysql> select count(1) from categories -> ; +----------+ | count(1) | +----------+ | 43 | +----------+

[BBCapMegane]

mysql> select count(1) from configs; +----------+ | count(1) | +----------+ | 2 | +----------+

[BBCapMegane]

mysql> select count(1) from items; +----------+ | count(1) | +----------+ | 50033 | +----------+

[BBCapMegane]

mysql> select count(1) from shippings; +----------+ | count(1) | +----------+ | 15034 | +----------+

[BBCapMegane]

mysql> select count(1) from transaction_evidences; +----------+ | count(1) | +----------+ | 15034 | +----------+

[BBCapMegane]

mysql> select count(1) from users; +----------+ | count(1) | +----------+ | 4000 | +----------+