Find Last Message FROM All Users

 Query to find out the last message from all users in conversation

select messages.message_text, messages.sender_uuid, messages.receiver_uuid, messages.add_date  FROM messages 
INNER JOIN (
SELECT  MAX(add_date) AS time, IF(`receiver_uuid` = '1',  `sender_uuid`, `receiver_uuid`) AS user FROM     dp_messages GROUP BY user) m2 
ON messages .add_date = m2.time 
AND (messages .`sender_uuid` = m2.user  OR dp_messages .`receiver_uuid` = m2.user)
WHERE 
`sender_uuid` = '1' OR `receiver_uuid` = '1' 
ORDER BY messages .add_date DESC LIMIT 0, 20

Mysql, Query to find out table comments?

To List all tables from database use: 

show tables from DatabaseName;

To List Table Structure you can use: 

DESC tablename;
Or You can use
SHOW COLUMNS FROM file FROM DatabaseName;

Query to find out Comments on Table

SELECT a.COLUMN_NAME, a.COLUMN_COMMENT FROM information_schema.COLUMNS a WHERE a.TABLE_NAME = 'YOUR_TABLE_NAME'

Just Change the name of YOUR_TABLE_NAME and run it.