1. 进入mysql: mysql -uroot -p
2. 进入名为hc1的库: use hc1
3. 执行查询语句:
数据库组合查询
SELECT bin_name FROM test_adas_header where ( event_time>="2021-02-28 15:00:23" and event_time<"2022-03-08 22:31:23" )
SELECT bin_name FROM event_test where ( event_time>="2021-02-28 15:00:23" and event_time<"2022-03-08 22:31:23" )
SELECT bin_name FROM test_adas_header where ( event_time>="2021-02-28 15:00:23" and event_time<"2022-03-08 22:31:23" )
SELECT bin_name FROM test_adas_header where ( event_time="20" )
4. 显示查询时间: show profiles;