msql
菜菜菜菜菜鸡
这个作者很懒,什么都没留下…
展开
-
linux安装mysql5.7
1.wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm2.yum -y localinstall mysql57-community-release-el7-8.noarch.rpm3.yum -y install mysql-community-server4.systemctl start mysqld //启动mysql5.cat /var/log/mysqld.log | grep passwor原创 2020-11-11 16:59:04 · 153 阅读 · 0 评论 -
SQL Server 按时间间隔提取数据
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...原创 2020-03-19 15:29:16 · 2741 阅读 · 0 评论