Is it possible to use bind_param in update query where column's name can dynamically changes?
for example
sql='update table_1 set ? = ? where id=?'
In the query above, I want to set the column name also by bind_param, but it causes error.
Asked
Active
Viewed 17 times
1
Oleksandr Pobuta
- 407
- 5
- 11
Art Croix
- 43
- 1
- 6
-
You can't bind columnames in mysql. – Michel Aug 03 '18 at 08:37
-
for db object as table or column name you can't use binding param but you could use dinamic sql .. (sql string dinamically cretated) – ScaisEdge Aug 03 '18 at 08:37
-
Understood.Thx to all – Art Croix Aug 03 '18 at 08:41