插入多行 SQL Teradata

Question

我正在创建一个易失性表并尝试向表中插入行。我可以像下面这样上传一行…

---

 create volatile table Example
(
    ProductID VARCHAR(15),
    Price DECIMAL (15,2)
)
on commit preserve rows;
et;

INSERT INTO Example
Values
('Steve',4);

---

但是，当我尝试上传多个时，我收到错误：

“语法错误：预期在 ‘)’ 和 ‘,’ 之间。”

 INSERT INTO Example
Values
('Steve',4),
('James',8);

原文由 Bocean 发布，翻译遵循 CC BY-SA 4.0 许可协议

Answer 1

是的，你可以试试这个。

 INSERT INTO  Student
  SELECT (Name, Maths, Science, English)  FROM JSON_Table
        (ON (SELECT 1 id,cast('{"DataSet" : [
{"s":"m", "Name":"Tilak", "Maths":"90","Science":"40", "English":"60" },
{"s":"m", "Name":"Raj", "Maths":"30","Science":"20", "English":"10" }
]
}' AS json ) jsonCol)
USING rowexpr('$.DataSet[*]')
colexpr('[{"jsonpath":"$.s","type":"CHAR(1)"},{"jsonpath":"$.Name","type":"VARCHAR(30)"}, {"jsonpath":"$.Maths","type":"INTEGER"}, {"jsonpath":"$.Science","type":"INTEGER"}, {"jsonpath":"$.English","type":"INTEGER"}]')
) AS JT(id,State,Name, Maths, Science, English)

原文由 Enrico Cloralio 发布，翻译遵循 CC BY-SA 4.0 许可协议