Golang操作mysql简单示例

package main import ( "database/sql" "fmt" _ "github.com/go-sql-driver/mysql" ) type Tag struct { ID   int    `json:"id"` Name string `json:"name"` } func main() { var recList = []Tag{} db, err := sql.Open("mysql", "root:linuxer@tcp(127.0.0.1:3306)/study") if err != nil { panic(err.Error()) } defer db.Close() results, err := db.Query("SELECT id, name FROM t") if err != nil { panic(err.Error()) // proper error handling instead of panic in your app } fmt.Println(results) for results.Next() { var tag Tag // for each row, scan the result into our tag composite object err = results.Scan(&tag.ID, &tag.Name) recList = append(recList, tag) if err != nil { panic(err.Error()) // proper error handling instead of panic in your app } fmt.Println(recList) } }