停止使用

GROUP_CONCAT CONCAT_WS ORDER BY 组合使用SELECT tmi.id, tmi.task_name AS taskName, JSON_UNQUOTE( JSON_EXTRACT( tmi.cooperate_dept, '$[*].name' ) ) AS cooperateDeptName, tmi.create_time AS createTime, GROUP_CONCAT( CONCAT_WS ( ' : ', tmr.create_time, t

mysql运行show master status; 命令 查看binlog文件 如 mysql-bin.000020运行 命令 mysqlbinlog --no-defaults --database=数据库名称 --start-datetime=“2020-01-01 00:00:00” --stop-datetime=“2021-06-08 00:00:00” /usv/mysql/log/mysql-bin.000020 > /usv/mysql/log/mysql_restore..

#database1spring.datasource.wh.type=com.zaxxer.hikari.HikariDataSourcespring.datasource.wh.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.wh.jdbcUrl=jdbc:mysql://192.168.1.130:3306/wh?...

背景：本地执行同步服务将本地数据定时传输到远程服务器，一次发现线上表数据为空，连接远程执行drop table一直等待响应，无法删除解决方案：连接远程mysql将这些线程全部kill就可以正常删除了。 本地执行同步到线上服务的时候 突然网络中断导致一直锁表。...

//sql 版本SELECT id,estate_name,house_type,price FROM ( SELECT id,estate_name,house_type,price, ROW_NUMBER () OVER ( PARTITION BY estate_name,house_type ORDER BY price ASC) rownum FROM property ...

分组之后取每组之内根据排序字段的第一行值 （可以根据rownum 随便取）SELECT*FROM ( SELECT *, ROW_NUMBER () OVER ( PARTITION BY [分组字段] ORDER BY [排序字段] ) rownum FROM 表名 ) t WHERE rownum = 1分组之后取字段最大/最小值SELECT MAX(指定字段), [分组字段]...

SELECT SUM ( CASE WHEN area_name IS NULL THEN 0 ELSE 1 END ) AS '有值', COUNT ( id ) AS "总数" FROM beike_property

SELECT DISTINCT ( object_id ) FROM ( SELECT TOP 100 PERCENT a.*, b.cnt FROM weChat_share a LEFT JOIN ( SELECT object_id, COUNT ( object_id ) cnt FROM weChat_share WHERE type = 4 GROUP BY...

SELECT COUNT ( [size] ) num FROM crawler_publish_property WHERE CAST ( ISNULL( [size], 0 ) AS NUMERIC ( 10, 2 ) ) >= 0 AND CAST ( ISNULL( [size], 0 ) AS NUMERIC ( 10, 2 ) ) < 50Numeric(...

SELECT t1.num, t1.estate_name AS ename, t2.* FROM ( SELECT TOP 100 PERCENT COUNT ( estate_name ) num, estate_name FROM crawler_property GROUP BY estate_name ORDER BY num DESC ) t1 LEFT OUTER JOI...

SELECT type, CONVERT ( VARCHAR ( 100 ), t.create_time, 23 ) [date], COUNT ( id ) num FROM crawler_property t WHERE 1 = 1 GROUP BY type, CONVERT ( VARCHAR ( 100 ), t.create_time, 23 ) ORDER ...

SELECT * FROM crawler_property_copy1WHERE (user_mobile + estate_name ) IN ( SELECT user_mobile + estate_name FROM crawler_property_copy1 GROUP BY user_mobile, estate_name HAVING COUNT ( * ) >...

ALTER TABLE circle_like ADD UNIQUE KEY(read_circle_id, user_id);try{ circleLikeService.insertSelective(circleLike); Map&amp;lt;String, Object&amp;gt; map = new HashMap&amp;lt;&amp;gt;(); map.put(&quot;c...

例如表 业务需求：将code的值设置为A+id的值mysql命令：update permit_list setcode= concat('A',id) （更新字段信息： UPDATE permit_list SET OWNER= "admin；myself" WHERE CODE = "A0000"） UPDATE user SET address = concat(l

<select id="searchUser" parameterType="java.lang.String" resultType="com.datebook.vo.UserDetailVO"> select id,mobile,header,nickname,gender,birthday,signature,photoes,book_cnt from user where <

1 MySQL的版本 utf8mb4的最低mysql版本支持版本为5.5.3+，若不是，请升级到较新版本。2 MySQL驱动 5.1.34可用,最低不能低于5.1.13（开始没修改mysql的配置文件 导致服务器的mysql驱动jar包只能用5.1.13版本，升级版本就会报错，坑死）3 修改MySQL配置文件 修改mysql配置文件my.cnf（windows为my.ini） my.cnf

需求：使用MyBatis往MySQL数据库中插入一条记录后，需要返回该条记录的自增主键值。方法：在mapper中指定keyProperty属性，示例如下：<insert id="addCoupon" parameterType="com.datebook.entity.Coupon" useGeneratedKeys="true" keyProperty="id"> insert into

1. findByIds(List ids)如果参数的类型是List, 则在使用时，collection属性要必须指定为 list<select id="findByIdsMap" resultMap="BaseResultMap"> Select <include refid="Base_Column_List" /> from jria where ID in <fore

https://hacpai.com/article/1492794464875