devxlogo

Updating Many Columns

Updating Many Columns

Question:
I’m looking for a syntax that can be used to update several columns in an SQLtable. Although I’ve found a number of topics related to ‘update’, they allseem to use the ‘set’ statement for one or two fields only.

Answer:
The standard UPDATE syntax for updating many columns is the same,regardless of the number of columns being updated. This can make for alengthy statement if you are updating many columns, so if your databasesupports PROCEDUREs (or other specialized extensions), creating and callinga PROCEDURE that handles the UDPATE is often a good solution.

As analternative, many application development languages include their own”shortcuts” around this problem, allowing you to store the data from theuser’s input screen into variables that can be substituted into the SQLUPDATE statement.

devx-admin

Share the Post: