MySQL Forums
Forum List  »  Connector/ODBC

Syntax to access the remote database/server
Posted by: Poorna Sravan Bhogavilli
Date: June 23, 2020 08:55AM

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.

Options: ReplyQuote




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.