finchxxia opened a new issue, #2150:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2150
I think we should support updates multiple tables by inserting one or more
rows with column values (from a query) into the tables. Supports both
unconditional and conditional inserts.
Example:
```
INSERT ALL
INTO t1
INTO t1 (c1, c2, c3) VALUES (n2, n1, DEFAULT)
INTO t2 (c1, c2, c3)
INTO t2 VALUES (n3, n2, n1)
SELECT n1, n2, n3 from src;
-- If t1 and t2 need to be truncated before inserting, OVERWRITE must be
specified
INSERT OVERWRITE ALL
INTO t1
INTO t1 (c1, c2, c3) VALUES (n2, n1, DEFAULT)
INTO t2 (c1, c2, c3)
INTO t2 VALUES (n3, n2, n1)
SELECT n1, n2, n3 from src;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
