in reply to DBI Update dynamically

Hi, it's not possible to UPDATE without knowing the column names. You could get them via a SELECT prior to your UPDATE.

In any case it would not be a good design to do what you want since your program would break as soon as the DB schema changes with a new column added or one removed, etc.

Hope this helps!


The way forward always starts with a minimal test.