删除数据¶
示例如下,省略数据库连接操作:
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)
}