I am trying to create a prepared statement in using the Golang sqlx library. I want to have the table name be a bindVar
stmt, err := stmtTx.Preparex("SELECT * FROM $1 WHERE question_id=$2;")
However this gives me an syntax error around /$1/
. Can I not use a bind var for the table name?
Can I not use a bind var for the table name?
No, source of quote.
The arguments can only be used as data values, not as identifiers. Thus for example this is reasonable:
INSERT INTO mytable VALUES ($1);
but this will not work:
INSERT INTO $1 VALUES (42);
But you can use fmt.Sprintf
for the table name if you want but leave the $1, $2, ... for the data values.
See this page for a general solution: