使用golang在mysql中创建数据库

Question

This question already has an answer here:

• How to create a new MySQL database with go-sql-driver 2 answers

I have a code that should create automatically database and table in mysql if they are not exist.

I can create table if I have DB, but I cannot create DB, because in connection string I should provide dbname.

db, err := sql.Open("mysql", "user:pass@tcp(localhost:3306)/dbname?charset=utf8")

Is it possible to do it with sql package?

</div>

Answer 1

Yes, just omit the database name from the url, and run a CREATE query. After that you can open a connection to your database.