There's more than one way to do things | |
PerlMonks |
Re: DBI Update dynamicallyby 1nickt (Canon) |
on Feb 23, 2018 at 14:54 UTC ( [id://1209834]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|