Closed lukaseder closed 7 months ago
Various DML statements can be translated, including:
INSERT
INSERT .. VALUES
CREATE (n:Type { ... })
INSERT .. SELECT
MATCH .. CREATE
RETURNING
RETURN
ON DUPLICATE KEY UPDATE
ON CONFLICT
MERGE
UPDATE
DELETE
WHERE
USING
DELETE .. JOIN
ORDER BY .. LIMIT
Added truncate in 1e45331.
truncate
Kamino closed and cloned this issue to neo4j/neo4j-jdbc
Various DML statements can be translated, including:
INSERT
: https://neo4j.com/docs/cypher-manual/current/clauses/create/INSERT .. VALUES
:CREATE (n:Type { ... })
syntaxINSERT .. SELECT
:MATCH .. CREATE
syntaxRETURNING
(Firebird, MariaDB, Oracle, PostgreSQL specific syntax to return deleted rows):RETURN
?ON DUPLICATE KEY UPDATE
/ON CONFLICT
: Probably usingMERGE
?UPDATE
: https://neo4j.com/docs/cypher-manual/current/clauses/merge/DELETE
: https://neo4j.com/docs/cypher-manual/current/clauses/delete/WHERE
: Translates toWHERE
USING
(PostgreSQL specificDELETE .. JOIN
syntax): Translates to ordinary graph declarationsORDER BY .. LIMIT
(MySQL specific syntax to limit the number of rows to be deleted): Perhaps with a subquery?RETURNING
(Firebird, MariaDB, Oracle, PostgreSQL specific syntax to return deleted rows): Perhaps withRETURN
?