一个 JSON 可以包含相同的键值吗? - Can a json contain same key value?

Can a json contain same key value?

本文关键字：键值包含相 JSON 一个 | 更新日期: 2023-09-27

我采用两个表的内容，执行这样的连接：

SELECT * FROM table1
     INNER JOIN table2
     ON table1.code = table2.code

现在table1有一个这样的结构：

|CODE|Info|Created          |Modified
|R789|Home|21/03/2016 10:00 |21/03/2016 15:00

和table2：

|CODE|Description|Created       |Modified
|R789|Testing| 21/03/2016 10:05 | 21/03/2016  18:10

现在的问题是查询返回以下结果：

"Code":"RB01",
"Info":Home,
"Created":"21/03/2016 10:05",
"Modified":"21/03/2016 18:10",
"Description":"Testing"

你怎么看我在两个表中有相同的created和modified。因此，查询会丢弃table1的created和modified。这对我来说是一个问题，我怎样才能避免这种情况？

需要使用 AS 关键字为列名创建别名。考虑一下：

SELECT t1.CODE, t1.Info, t1.Created AS t1Created, t1.Modified AS t1Modified, t2.Description, t2.Created AS t2Created, t2.Modified AS t2Modified
    FROM table1 t1
    INNER JOIN table2 t2 ON t1.CODE = t2.CODE

这将返回

"Code":"RB01",
"Info":Home,
"t1Created":"21/03/2016 10:00",
"t1Modified":"21/03/2016 15:00",
"Description":"Testing",
"t2Created":"21/03/2016 10:05",
"t2Modified":"21/03/2016 18:10",