当前位置:网站首页>查询2013年到2021年的数据,只查询到2020的数据,遇到了这个问题所进行的解决办法
查询2013年到2021年的数据,只查询到2020的数据,遇到了这个问题所进行的解决办法
2022-04-23 14:04:00 【黄哈哈~】
sql中取到2021,只查到2020年的数据,其余2021年的数据查出来了,然后单独查询这个系列的2021年的数据,它是有数据的,这是我遇到比较奇怪,变态的问题。
解决办法:
在年份plan_year=‘2013’后面加一个连接符号和两个单引号||’’,2021年的数据成功查询出来了,记录一下这个变态问题。已提醒自己!!!!

版权声明
本文为[黄哈哈~]所创,转载请带上原文链接,感谢
https://blog.csdn.net/Miss_HuangT/article/details/116232053
边栏推荐
- Logging模块
- Force deduction brush question 101 Symmetric binary tree
- 关于pthread多线程一些好文章
- Lin Lin, product manager of Lenovo: network failure of local network operator in Tianjin. The background server of Zui system can't work normally for the time being
- Mock测试
- 基于Ocelot的gRpc网关
- Detailed tutorial on the use of smoke sensor (mq-2) (based on raspberry pie 3B +)
- 网站_收藏
- New关键字的学习和总结
- Easyexcel读取excel表地理位置数据,按中文拼音排序
猜你喜欢

Nacos+AspnetCore+Ocelot实战编码

As a junior college student, I studied hard in closed doors for 56 days, won Ali offer with tears, five rounds of interviews and six hours of soul torture

Business case | how to promote the activity of sports and health app users? It is enough to do these points well

程序编译调试学习记录

1256: bouquet for algenon

Prediction of tomorrow's trading limit of Low Frequency Quantization

基于CM管理的CDH集群集成Phoenix

There is a mining virus in the server

Universal template for scikit learn model construction

Pycharm连接远程服务器并实现远程调试
随机推荐
Choreographer full resolution
快捷键(多行)
Jacob print word
Promtail + Loki + Grafana 日志监控系统搭建
PATH环境变量
The latest development of fed digital currency
There is a mining virus in the server
记录一个奇怪的bug:缓存组件跳转之后出现组件复制
Programming travel function
Use of WiFi module based on wechat applet
New关键字的学习和总结
编程旅行之函数
POI operation word template replaces data and exports word
快速安装mongodb
leetcode--380. O (1) time insertion, deletion and acquisition of random elements
Ptorch classical convolutional neural network lenet
FBS(fman build system)打包
_模_板_
linux MySQL数据定时dump
leetcode--357. Count the number of different figures