gpt4 book ai didi

php - 一个 mysql 表中的水平循环器

转载 作者:行者123 更新时间:2023-11-29 01:49:39 27 4
gpt4 key购买 nike

<分区>

我有一个 mysql 表:

每个用户有 4 个邮箱:

 id user_Id email
1 11 emailx@email.com
2 11 emailc@email.com
3 11 emaild@email.com
4 11 emailv@email.com
5 12 emailr@email.com
6 12 emailb@email.com
7 12 emailW@email.com
8 12 emailT@email.com
9 13 emailJ@email.com
10 13 emailI@email.com
11 13 emailL@email.com
12 13 emailQ@email.com

如何水平排序行结果?

像那样:

 user_Id   email1           email2           email3             email4
11 emailx@email.com emailc@email.com emaild@email.com emailv@email.com
12 emailr@email.com emailb@email.com emailW@email.com emailT@email.com
13 emailJ@email.com emailI@email.com emailL@email.com emailQ@email.com

27 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com