Golang查詢MySQL資料庫
摘要:
模組安裝
goget-u github.com/go-sql-driver/mysql
程式碼
package main
import (
"database/sql"
_"github.com/go-sql-driver/mysql&...
模組安裝
goget-u github.com/go-sql-driver/mysql
程式碼
package main import ( "database/sql" _"github.com/go-sql-driver/mysql" "log" "fmt" ) funcmain(){ db,err :=sql.Open("mysql","root:@tcp(127.0.0.1:3306)/nginxlog") //連線資料庫 checkErr(err) rows,err :=db.Query("select*fromnginxloglimit10; ") checkErr(err) for rows.Next(){ var idint var ipstring var timestring varmethods string varsourcestring varprotocolstring var status string err = rows.Scan(&id,&ip,&time,&methods,&protocol,&status,&source) checkErr(err) fmt.Println(id,ip,time,methods,status,source) } } //校驗函式 funccheckErr(err error){ iferr!= nil{ log.Println(err) } }
資料庫的資料內容
Golang查詢的結果: