Create database in mysql with golang [duplicate]

Question

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?

Not_a_Golfer · Accepted Answer · 2015-05-22 10:03:39Z

0

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

answered May 22, 2015 at 10:03

Not_a_Golfer

49.5k15 gold badges130 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1