MySQL 学习记录①

自制思维导图，用来记忆和复习。

用Go语言实现数据修改功能

// 插入
func insert() {
    sqlStr := `insert into user(name, age) values("效果", 29)`
    ret, err := db.Exec(sqlStr)
    if err != nil {
        fmt.Printf("intert failed,err:%v\n", err)
        return
    }
    id, err := ret.LastInsertId()
    if err != nil {
        fmt.Printf("get id failed,err:%v\n", err)
        return
    }
    fmt.Println("id:", id)
}

// 更新
func updateRow(newAge int, id int) {
    sqlStr := `update user set age=? where id = ?`
    ret, err := db.Exec(sqlStr, newAge, id)
    if err != nil {
        fmt.Printf("update failed,err:%v\n", err)
        return
    }
    n, err := ret.RowsAffected()
    if err != nil {
        fmt.Printf("get id failed,err:%v\n", err)
        return
    }
    fmt.Printf("更新了%d行数据\n", n)
}

// 删除
func deleteRow(id int) {
    sqlStr := `delete from user where id = ?`
    ret, err := db.Exec(sqlStr, id)
    if err != nil {
        fmt.Printf("get failed,err:%v\n", err)
        return
    }
    n, err := ret.RowsAffected()
    if err != nil {
        fmt.Printf("get id failed,err:%v\n", err)
        return
    }
    fmt.Printf("删除了%d行数据\n", n)
}