我有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/