Mysql a table grouped according to two fields to remove weight, is there a SQL boss (I have solved it myself)

Kotlin
IOS
VB.Net
SQL
Node.js
Swift
Ruby
Go
Oracle
Git
Laravel
Mongodb
Asp.Net
More...

demand background

A message record table that takes out the message records related to the current user, and then the previous messages of the two same users show only the latest message, and remove the message

repeatedly.

Datasheet

8,, :
1,4,5

,sql,

group,idid id
8,group send_time ok

Mysql php lavarel

Mar.28,2021

which field does your current user correspond to, and why do you take record 1, 4, 4, 5, instead of record 3, 4, 4, 5

just provides an idea. You need to consider the performance yourself

// 
SELECT * FROM (SELECT * FROM message ORDER BY send_time DESC ) AS tempData GROUP BY from_user_id ORDER BY id ASC

Previous: Js click method how to change the click object dynamically

Next: Js sequence number rearrangement problem

False
Django, Why does the system automatically generate an empty session? every time the request is made?
Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.
How to self-start the php-fpm service when building a LNMP environment with docker?
Can an array in react state be bound to a dom state using an element in the array?
Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.
In express+hbs, how do you define the routed data as a variable on the page?
How to use symbol reference of Iconfont in dva
How to elegantly add data to JSON objects?
Using node to build video streaming server
The proportional width of the echarts graph is inconsistent.
React uses axios to call the background data. After success, how to jump to the page based on the returned value?
I don't understand what a linux command means. Please explain it.
Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.
Running nodejs reports fewer errors ")"

Lose focus and input enter trigger function
Regular removal of emoji expression production environment is invalid
Java reads txt text content, how to make each line of content separated by spaces and converted to float type storage?
Does the branch of git have to be built on the main branch of master? can you create a branch on the branch?
Jqueryu problem Mouse move in and out remove default style Toggle style