插入数据¶
示例如下,省略数据库连接操作:
func insertWithParam1(db * sql.DB){
var err error
var result sql.Result
var rowsAffected int64
var insertSQL string = "insert into testcase1(col1, col2) values(:1, :2)"
var tStr string = "hello2!"
result, err = db.Exec(insertSQL, 10, tStr)
getError(err)
rowsAffected, err = result.RowsAffected()
getError(err)
fmt.Println(rowsAffected)
}