Syntax to access the remote database/server
I am trying to establish a connection from a local database on my PC to the database hosted on a server, in this case it is in AWS MYSQL server.
I tried the syntax like
insert into [xxx.rds.amazonaws.com][database_name][user_name][table_name]
UPDATE [xxx.rds.amazonaws.com][database_name][user_name][table_name]
SET vin=b.vin
FROM [xxx.rds.amazonaws.com][database_name][user_name][table_name] a,
INNER JOIN [localhost][name_of_local_databse][user_name][table_name] b ON (a.serial_number=b.serial_number)
WHERE b.serial_number=1;
But, I am not able to connect to the other database. Could someone help?
Thanks in advance.
Subject
Written By
Posted
Syntax to access the remote database/server
June 23, 2020 08:55AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.