mysql 查询结果为map

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "user:password@tcp(127.0.0.1:3306)/dbname")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    rows, err := db.Query("SELECT id, name, age FROM users")
    if err != nil {
        panic(err)
    }
    defer rows.Close()

    columns, err := rows.Columns()
    if err != nil {
        panic(err)
    }

    for rows.Next() {
        values := make([]interface{}, len(columns))
        scanArgs := make([]interface{}, len(columns))
        for i := range values {
            scanArgs[i] = &values[i]
        }

        err = rows.Scan(scanArgs...)
        if err != nil {
            panic(err)
        }

        record := make(map[string]interface{})
        for i, col := range columns {
            var v interface{}
            val := values[i]
            b, ok := val.([]byte)
            if ok {
                v = string(b)
            } else {
                v = val
            }
            record[col] = v
        }

        fmt.Println(record)
    }

    if err = rows.Err(); err != nil {
        panic(err)
    }
}