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.

See also  How to Avoid Money Transfer Scams  
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist