dylan_XK的博客

多表关联修改内容批量UPDATE table1 AS ajINNER JOIN table2 AS a ON aj.table1id = a.idINNER JOIN table3 AS mp ON a.table2d = mp.idINNER JOIN table4 AS mlc ON mp.table3id = mlc.idINNER JOIN table5 AS mlcp ON mlc.table4id = mlcp.idINNER JOIN table6 AS ac ON ac.typ

SELECTa.user_id,a.id,a.evidence_pic,a.activity_id,COUNT(1) AS numFROM(SELECT*FROMactivityWHERE user_id IN#{tiem}AND evidence_pic IS NOT NULLAND activity_id != #{activityId}) aINNER JOIN (SELECT*FROMactivityWHERE user_id IN#{tiem}AN

用户输入-1得时候查询当年得数据 当输入1-12得时候查询当年对应月份得数据 Calendar startCalendar = Calendar.getInstance(); Calendar endCalendar = Calendar.getInstance(); if(-1 == inputVO.getTime()){ //设置开始月份 startCalendar.set(Calendar.MONTH,0); ..

查询在表中user_id与activity_id 在 计数多余1的时候的数据并且去除ID小的，留下id大的（最新数据）SELECT t1.id FROM 表名 t1 WHERE (t1.user_id, t1.activity_id) IN(SELECT user_id, activity_id FROM 表名 GROUP BY user_id, activity_id HAVING COUNT() > 1)AND t1.

增加一列 这一列的备注说明信息ALTER TABLE 表名 ADD 增加的列名 DATETIME COMMENT ‘顶置’ AFTER 跟在哪一个列后面做顶置排序的时候增加一列 时间列 先看这个看这个顶置列是不是空的， 将不为空的先 倒序，如果为空按照创建时间倒序排列SELECT * FROM 表名 ORDER BY 时间顶置（列名） IS NULL, 时间顶置（列名）DESC,create_time DESC取消顶置就将顶置的字段置空UPDATE 表名 S