id, type, user_id, isread, title, content, create_time select from cab_mymessage where id = #{id,jdbcType=INTEGER} delete from cab_mymessage where id = #{id,jdbcType=INTEGER} insert into cab_mymessage (id, type, user_id, isread, title, content, create_time) values (#{id,jdbcType=INTEGER}, #{type,jdbcType=INTEGER}, #{userId,jdbcType=VARCHAR}, #{isread,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR}, #{content,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}) insert into cab_mymessage id, type, user_id, isread, title, content, create_time, #{id,jdbcType=INTEGER}, #{type,jdbcType=INTEGER}, #{userId,jdbcType=VARCHAR}, #{isread,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR}, #{content,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, update cab_mymessage type = #{type,jdbcType=INTEGER}, user_id = #{userId,jdbcType=VARCHAR}, isread = #{isread,jdbcType=INTEGER}, title = #{title,jdbcType=VARCHAR}, content = #{content,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP}, where id = #{id,jdbcType=INTEGER} update cab_mymessage set type = #{type,jdbcType=INTEGER}, user_id = #{userId,jdbcType=VARCHAR}, isread = #{isread,jdbcType=INTEGER}, title = #{title,jdbcType=VARCHAR}, content = #{content,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=INTEGER} select t.type, count(*) typeCount, t.content, t.create_time from ( select type ,content , create_time from cab_mymessage where user_id = #{userId,jdbcType=VARCHAR} and isread = 0 and isread = 1 order by create_time desc ) t group by type ORDER BY t.create_time DESC select * from cab_mymessage where user_id = #{userId,jdbcType=VARCHAR} and type = #{type,jdbcType=INTEGER} and isread = 0 and isread = 1 order by create_time asc select COUNT(id) from cab_mymessage where user_id=#{userId,jdbcType=VARCHAR} and isread = 0 update cab_mymessage set isread = 1 where user_id = #{userId,jdbcType=VARCHAR} and isread = 0 and type in (0,1,2,3,4)