例如,One mysql server machine A has One table called "tableA" under in a database called databaseA, anothermysql server machine B has one table called "tableB" under in a database called databaseB.如何加入tableA
我想使用RStudio来分析MySQL实例上的数据。这是一个AWS实例,它只能通过跳转框/堡垒主机访问。我拥有连接到跳转框和从跳转框到RDS实例所需的凭据。然后我可以使用: mysql -u用户名-p数据库-h hostname.us-east-1.rds.amazonaws.com连接到RDS mysql。我可以在RStudio终端内连接和执行手动mysql命令,但我似乎无法从RStudio控制台对DB进行任何操作。