Is it possible to display a two-dimensional table in the console in MySQl SELECT?

Question

MySQL

For example, a request

SELECT user_id, count(user_id) FROM Message WHERE date='2018-01-01' GROUP BY user_id;

displays the number of messages from each user for the date 2018-01-01.
Is it possible to somehow continue the table to the right with columns '2018-01-02', '2018-01-03', etc.?

Answer 1

Obviously, the correct option to make such a query would be group by user_id, date.
But, if you want entertainment and cross-query output in MS Access style, you can use the same MySQL to form a query that will perform the required SELECT. Example: https://ru.stackoverflow.com/questions/764260/mysq...