+
--------------------+
| Database |
+
--------------------+
| __recycle_bin__ |
| hx-marking |
| information_schema |
| mysql |
| performance_schema |
| sys |
| waymo_db |
+
--------------------+
7 rows in set (0.00 sec)
--
登
⼊
数
据
库
mysql> use waymo_db;
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
--
查
看
数
据
库
中
所
有
的
表
:
SELECT table_name FROM information_schema.tables
--
查
看
指
定
数
据
库
中
所
有
的
表
mysql> SELECT table_name FROM information_schema.tables WHERE table_schema = 'wa
+
--------------+
| TABLE_NAME |
+
--------------+
| camera_calib |
| camera_data |
| clip |
| clip_x_frame |
| ego_pose |
| frame |
| lidar_calib |
| lidar_data |
+
--------------+
8 rows in set (0.00 sec)
--
查
看
每
个
表
有
多
少
⾏
(
row
;
item
)
mysql> SELECT table_name, table_rows
-> FROM INFORMATION_SCHEMA.TABLES
-> WHERE TABLE_SCHEMA = 'waymo_db';
+
--------------+------------+
| TABLE_NAME | TABLE_ROWS |
+
--------------+------------+
| camera_calib | 2968 |
| camera_data | 2940 |
| clip | 3 |