Mysql操作专题

增删改查

package main

import (
"database/sql"
"fmt"

_ "github.com/go-sql-driver/mysql" // import your used driver
)

func main() {
    //获取*db
    db, _ := sql.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/telephone?charset=utf8")
    defer db.Close()

    stmt,_:=db.Prepare("insert telephone (tel) values (?)")
    defer stmt.Close()

    ret,err:=stmt.Exec("13899008899")
    last_id,_:=ret.LastInsertId()
    fmt.Println(err.Error(),last_id)
}