qq_24084605的博客

1.wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm 2.yum -y localinstall mysql57-community-release-el7-8.noarch.rpm 3.yum -y install mysql-community-server 4.systemctl start mysqld //启动mysql 5.cat /var/log/mysqld.log | grep passwor

select a.* from table a where collectionTime between cast('2019-10-03 00:00:00' as datetime) and cast('2020-03-13 13:55:00' as datetime) and datediff(minute,'2019-10-03 00:00:00',a.collectionTi...