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, you can't reply to this topic. It has been closed.

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.