- 1使用Verilog实现CRC-8的串行计算_crc8 verilog
- 2大数据、人工智能、云计算、物联网、区块链序言【大数据导论】_大数据、云计算、物联网相关概念普及
- 3spring.HttpMessageNotReadableException: JSON parse error_spring json parse error
- 4springboot整合redisson实战（一）整合 redisson-spring-boot-starter
- 5设置了uni.chooseLocation，小程序中打不开_uni.chooselocation点击之后没反应
- 6头歌实验代码_表格样式头歌代码
- 7mysql的clob转字符串_Oracle中clob与varchar字段互转
- 8日常学习记录——使用Visio2019绘制思维导图_visio画大括号思维导图
- 9【数据结构】：冒泡排序（c++实现）_c++冒泡排序统计轮数
- 10chatgpt赋能python：Python选择界面的SEO介绍
代替mysql_mysql 替代子查询
赞
踩
//in子查询的写法 我自己的mysql支持 服务器不支持
(select user_no,videofile from user_info where phone in(SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone not in(SELECT receiver from pair_info where caller='1365555'and receive_invite_flag=2 and createtime>=now()) and status=1 and top_flag=1 and valid_top_datetime>now() order by lastupdatetime desc) union (select user_no,videofile from user_info where phone in(SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone not in(SELECT receiver from pair_info where caller='1365555' and receive_invite_flag=2 and createtime>=now()) and status=1 and top_flag=0 order by lastupdatetime desc)
//不支持in 看看 any行不,还是不行
(select user_no,videofile from user_info where phone = any (SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone != any (SELECT receiver from pair_info where caller='1365555' and receive_invite_flag=2 and createtime>=now()) and status=1 and top_flag=1 and valid_top_datetime>now() order by lastupdatetime desc) union (select user_no,videofile from user_info where phone = any(SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone != any(SELECT receiver from pair_info where caller='1365555' and receive_invite_flag=2
