I am trying to use named parameter query in golang as follows:
stmt, err := db.Prepare("insert into users(name, email) values(@name, @email)")
if err != nil {
//error handling
}
res, err := stmt.Exec(sql.Named("name", name), sql.Named("email", email))
if err != nil {
//error: sql: expected 0 arguments, got 2
}
I get the following error: "sql: expected 0 arguments, got 2".
What is correct way to write this query?