On Thu, Oct 29, 2020 at 9:16 AM Paul Förster <paul.foerster@xxxxxxxxx> wrote:
But I guess that Emacs shows the matching closing bracket at the beginning of the line, which matches that single tuple. But you also need a closing bracket for the set of tuples like this:
insert ...
(
(v1, v2, v3),
(v4, v5, v6),
(v7, v8, v9) <= this is the bracket pair that Emacs shows as matching.
); <= this is the missing bracket.
Except that isn't valid INSERT statement syntax. You are missing "values" and there is no enclosing parens:
INSERT INTO tbl (i) VALUES (1), (2), (3); --this is perfectly valid
That said seeing the first few rows, in addition to the last few, would help.
David J.
