我想使用sql库在Golang中执行以下类型的查询:
rows, err := db.Query("select * from someTable where age = ? and hairColor = ?", age,haircolor)
但是会收到以下类型的错误:
Error occured: sql: expected 1 arguments, got 2
如何在Golang中执行带有多个值的WHERE子句的SQL SELECT语句?
我想使用sql库在Golang中执行以下类型的查询:
rows, err := db.Query("select * from someTable where age = ? and hairColor = ?", age,haircolor)
但是会收到以下类型的错误:
Error occured: sql: expected 1 arguments, got 2
如何在Golang中执行带有多个值的WHERE子句的SQL SELECT语句?
答案是使用预处理语句,所以在我的示例中:
stmt, err := db.Prepare("select * from someTable where age = ? and hairColor = ?")
rows, err := stmt.Query(age,hairColor)
这在回顾时似乎很明显。希望这能为未来节省一些时间和烦恼!