让mysql竖着显示

CREATE TABLE users (
    id INT,
    name VARCHAR(50),
    email VARCHAR(100)
);

INSERT INTO users (id, name, email) VALUES
(1, 'Alice', 'alice@example.com'),
(2, 'Bob', 'bob@example.com');

SELECT 'id' AS col, id AS val FROM users
UNION ALL
SELECT 'name' AS col, name AS val FROM users
UNION ALL
SELECT 'email' AS col, email AS val FROM users;

import pandas as pd
import mysql.connector

# 连接到MySQL数据库
conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
cursor = conn.cursor()

# 执行查询
cursor.execute("SELECT * FROM users")
result = cursor.fetchall()

# 将结果转换为DataFrame并竖着显示
df = pd.DataFrame(result, columns=[desc[0] for desc in cursor.description])
print(df.T)