- Install the github.com/go-sql-driver/mysql and github.com/gorilla/mux packages using the go get command, as follows:
$ go get github.com/go-sql-driver/mysql$ go get github.com/gorilla/mux
- Create read-record-mysql.go where we connect to the MySQL database, perform a SELECT query to get all the employees from the database, iterate over the records, copy its value into the struct, add all of them to a list, and write it to an HTTP response stream, as follows:
package mainimport ( "database/sql" "encoding/json" "log" "net/http" "github.com/go-sql-driver/mysql" "github.com/gorilla/mux")const ( CONN_HOST = "localhost" CONN_PORT = "8080" DRIVER_NAME = "mysql" DATA_SOURCE_NAME = "root:password@/mydb")var db *sql.DBvar connectionError ...
