Comments - UPDATE
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Dear Mr.,
I have problems sending a update statement from on db on server to a table in an other db on the same server which is connected via CONNECT Engine to a second server.
In the insert statement It is possible to use db.table to reference to the table: i.e. INSERT INTO db.table (COLUMN1, COLUMN2) VALUES (VALUE1, VALUE2)
in the update statement I got an error if I use 'db.table'. It only works on the db directly connected via the connect engine.
SQL Error (1296): Got error 122 'Remote: Table 'db.table' doesn't exist' from CONNECT
What can I do to use the update statement?
Best Regards