我有2张桌子

表格1

===================================
= Id = Name             =  email  =
===================================
= 1  = David            = d@d.com =
===================================


表2

==================================
= uid = key        =  Value      =
==================================
= 1   = Age        =  18         =
= 1   = Tele       =  0123456798 =
==================================


这个想法是UID与ID相关联以链接表。

我想做的是运行一个SQL查询以获取以下输出。

=========================================================================
= Id = Name             =  email  = age        =  Tele                  =
=========================================================================
= 1  = David            = d@d.com = 18         = 012345678              =
=========================================================================


我需要运行什么查询。

谢谢

最佳答案

像这样:

select
  t.Id,
  t.Name,
  t.Email,
  (select Value from Table2 t2 where t2.uid = t.Id and t2.Key = 'Age') as Age,
  (select Value from Table2 t2 where t2.uid = t.Id and t2.Key = 'Tele') as Tele

from Table1 t


如果您事先知道密钥,则上面的查询将起作用。
它的名称未知,从数据库中获取可用的键名称列表:

select distinct Key from Table2

关于mysql - 带有元数据的SELECT行,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/13865345/

10-11 12:32
查看更多