删除数据

示例如下,省略数据库连接操作:

func deleteWithParam(db * sql.DB){
        var err          error
        var result       sql.Result
        var rowsAffected int64
        var deleteSQL    string = "delete from testcase1 where col1 = :1"

        result, err = db.Exec(deleteSQL, 10)
        getError(err)

        rowsAffected, err = result.RowsAffected()
        getError(err)
        fmt.Println(rowsAffected)
}