![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
ZiHai子海
这个作者很懒,什么都没留下…
展开
-
Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist:
Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: ch检查数据库中字段数据类型是否一直(ps:仅此记录工作中遇到的错误)原创 2022-03-18 21:34:35 · 4841 阅读 · 0 评论 -
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rea
mysql报错1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘realname.t_act_coding1.nin_coding’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou原创 2021-09-28 19:19:19 · 1709 阅读 · 0 评论 -
mysql查询两张表中不相同的数据
需求是:表A跟表B字段相同,数据有重复的,查询出表B跟表A不同的数据SELECT phone FROM wzhone WHERE phone NOT IN ( SELECT phone FROM wzh )表A表B查询结果是剔除表B跟表A相同的数据原创 2021-04-22 20:59:01 · 5545 阅读 · 1 评论 -
对于mybatis在一定时间范围内查询数据
记录一条容易遗忘的点.对于mybatis时间范围内查询数据是我sql记录.select name,phone,DATE_FORMAT(create_time, '%Y-%m-%d %H:%i:%s') create_time from t_1702_user where 1=1 <if test="startTime !=null and startTime !=''"> AND create_time <![CDATA[ >= ]]>原创 2021-03-05 16:14:26 · 393 阅读 · 0 评论 -
sql 将一个表中的查询出来的数据更新到另外一个表中
需求:查询结果将数据更新到另外一个表中的指定某个字段.我先记录了我查询出来的结果,导入mysql中新建的临时表.将数据phone字段的数据导入到t_1301_checkEveryDay这个数据表中.UPDATE t_1301_checkEveryDay s,linshi c SET s.phone = c.phone WHERE s.openId = c.openid AND s.city = c.city;顺便记录一下自己查询的mysql语句这里面 openid 和city是相互原创 2021-03-02 19:06:58 · 1465 阅读 · 0 评论