Julia没有选择MySQL数据库

Question

我创建了一个连接，并尝试在其中执行一些sql；im获取错误(1046): no database selected

using DBInterface
using MySQL
con = DBInterface.connect(MySQL.Connection, "12345.rds.amazonaws.com", "admin", "54321")
sql = "CREATE TABLE friends2(last_name VARCHAR(10), first_name VARCHAR(20));"
DBInterface.execute(con, sql)
>> (1046): No database selected

当我运行DBInterface.connect(MySQL.Connection, "12345.amazonaws.com", "admin", "54321")时，我得到：

MySQL.Connection(host="12345.rds.amazonaws.com", user="admin", port="3306", db="")

但如果我在进行MySQL连接时输入数据库，我会得到(1049): Unknown database 'pg1'

我还注意到，尽管我已经运行了add MySQL，但当我尝试使用像mysql_connect这样的东西时，它不起作用：

conn = mysql_connect( "12345.us-east-2.rds.amazonaws.com", "admin", "54321", "db")
>>> connect not defined

不知道我在哪里搞砸了！

Answer 1

我很确定您必须将; db="my_db"传递给DBInterface.connect