如何从 mysql 查询中检索特定格式的数据 - How to retrieve data in a specific format from a mysql query?

How to retrieve data in a specific format from a mysql query?

我有一个表 = table1，这个表中的数据如下

user_id    user_name  count_activity  activity_name
1            ravi         2                login    
2            rahul        5                logout
1            ravi         6                send mail 
3            vinod        10               update authrization
2            rahul        50               delete authrization

我想使用这些数据来制作 3 个这样的视图。

First View                   Second View               Third View
Activity        Details     Activity     details     Activity       details 
user             ravi       user          rahul       user           vinod
login            2          logout         5          update auth..   10
send mail        6          delete auth..  50

select activity_name as Activity,count_activity as Details  from table where user_name ='ravi';

视图1

其他视图也是如此

要从数据库中获取数据，请执行以下查询：

select user_name, activity_name activity, count_activity as Details from <tablename> order by user_name

您可以根据需要添加 where 子句来获取数据。