Q&A BY TAG 'insert'

You must sign in to ask a question. If you do not have an account, you can register here

INSERT INTO with SELECT
answered 18-10-2021 04:32:01 -0400

Hi Team, Could you please confirm the below limitation of VQL syntax. Working - INSERT INTO view2 SELECT col1 FROM view1; Working - INSERT INTO view2 (col1) VALUES ("abc"); Not working - INSERT INTO view2 (col1) SELECT col1 FROM view1; Not working - ...

Answers: 3

VQL syntax insert

Denodo cross database insert
answered 17-09-2019 08:30:45 -0400

Hi, Is it possible to insert records in denodo from a base view of database vdb1 into another base view of database vdb2. Insert records into vdb1 from select * from vdb2; if the records exists we need to update those records.

Answers: 1

insert update