mysql设置最大查询时间_mysql如何限制sql查询时间

深碍√TFBOYSˉ_ 2023-01-11 03:46 148阅读 0赞

mysql限制sql查询时间的方法：1、查询今天，代码为【select \* from 表名 where to\_days(时间字段名) = to\_days(now())】；2、查询昨天，代码为【SELECT \* FROM 表名 WHERE】。

![2020121610490246972.jpg][]

本教程操作环境：windows7系统、mysql8.0.22版，该方法适用于所有品牌电脑。

相关免费学习推荐：mysql视频教程

mysql限制sql查询时间的方法：

今天select \* from 表名 where to\_days(时间字段名) = to\_days(now());

昨天SELECT \* FROM 表名 WHERE TO\_DAYS( NOW( ) ) - TO\_DAYS( 时间字段名) <= 1

近7天SELECT \* FROM 表名 where DATE\_SUB(CURDATE(), INTERVAL 7 DAY) <= date(时间字段名)

近30天SELECT \* FROM 表名 where DATE\_SUB(CURDATE(), INTERVAL 30 DAY) <= date(时间字段名)

本月SELECT \* FROM 表名 WHERE DATE\_FORMAT( 时间字段名, ‘%Y%m’ ) = DATE\_FORMAT( CURDATE( ) , ‘%Y%m’ )

上一月SELECT \* FROM 表名 WHERE PERIOD\_DIFF( date\_format( now( ) , ‘%Y%m’ ) , date\_format( 时间字段名, ‘%Y%m’ ) ) =1

查询本季度数据select \* from ht\_invoice\_information where QUARTER(create\_date)=QUARTER(now());

查询上季度数据select \* from ht\_invoice\_information where QUARTER(create\_date)=QUARTER(DATE\_SUB(now(),interval 1 QUARTER));

查询本年数据select \* from ht\_invoice\_information where YEAR(create\_date)=YEAR(NOW());

查询上年数据select \* from ht\_invoice\_information where year(create\_date)=year(date\_sub(now(),interval 1 year));

查询当前这周的数据SELECT name,submittime FROM enterprise WHERE YEARWEEK(date\_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now());

查询上周的数据SELECT name,submittime FROM enterprise WHERE YEARWEEK(date\_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now())-1;

查询上个月的数据select name,submittime from enterprise where date\_format(submittime,’%Y-%m’)=date\_format(DATE\_SUB(curdate(), INTERVAL 1 MONTH),’%Y-%m’)

select \* from user where DATE\_FORMAT(pudate,’%Y%m’) = DATE\_FORMAT(CURDATE(),’%Y%m’) ;

select \* from user where WEEKOFYEAR(FROM\_UNIXTIME(pudate,’%y-%m-%d’)) = WEEKOFYEAR(now())

select \* from user where MONTH(FROM\_UNIXTIME(pudate,’%y-%m-%d’)) = MONTH(now())

select \* from user where YEAR(FROM\_UNIXTIME(pudate,’%y-%m-%d’)) = YEAR(now()) and MONTH(FROM\_UNIXTIME(pudate,’%y-%m-%d’)) = MONTH(now())

select \* from user where pudate between 上月最后一天 and 下月第一天

查询当前月份的数据select name,submittime from enterprise where date\_format(submittime,’%Y-%m’)=date\_format(now(),’%Y-%m’)相关免费学习推荐：php编程(视频)

[2020121610490246972.jpg]: https://www.gxlcms.com/Uploads-s/new/2020-12-16-mysql/2020121610490246972.jpg

还没有评论，来说两句吧...