GoLang语言对MYSQL数据库的操作

通过引入database/sql和github.com/go-sql-driver/mysql来操作数据库:

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

var (
	dbhostip="127.0.0.1"
	dbusername="root"
	dbpassword=""
	dbname="test"
)
func checkErr(err error){
	if err!=nil{
		panic(err)
	}
}
func main(){
	db,err:=sql.Open("mysql",dbusername+":"+dbpassword+"@tcp("+dbhostip+")/"+dbname+"?charset=utf8")
	checkErr(err)
	result,err:=db.Exec("insert into user(user_name,time) values(12,12)")
	checkErr(err)
	fmt.Println(result.LastInsertId())
}