03、dml语句处理

dmi语句处理

package main
import (
    "database/sql"
    _ "github.com/go-sql-driver/mysql"
)
func main(){
driverName := "mysql"
dsn := "golang:golang@@2020@tcp(localhost:3306)/user?parseTime=true&loc=Local&charset=utf8mb4"
if err != nil{
fmt.Println(err)
return
}
defer db.Close()
sql :=`
insert into user(name,pasword,birthday) values("kk","xxxxxx","1999-11-11)
`
defer db.Close()
result,err:=db.Exec(sql)
if err !=nil{
    fmt.Println(err)
} else {
    fmt.Println(result.LastInsertId())
    fmt.Println(result.RowsAffected())
}
sql :=`update user set birthday=now()`
result,err=db.Exec(sql)
fmt.Println(err)
fmt.Println(result.LastInsertId())  // LastInsertId方法是返回
fmt.Println(result.RowsAffected())  // RowsAffected方法是
}