To update records in a table of data in DB2 is very simple, using UPDATE command from the syntax shown below quickly you realize that common action in the life of a programmer or DBA.

UPDATE [Table]

SET [Column] = [Value]

In the above syntax UPDATE command will update all records in the table as well as DELETE, for example, it is necessary to use the WHERE clause to avoid errors and inconsistencies in the data.

UPDATE tshirt

SET Size = ‘M’

 

UPDATE tshirt

SET Size = ‘M’

WHERE Brand = ‘XYZ’

In the examples given have the following situations, the first all records of the table will be updated with the size M. In the second, only the records of the brand ‘XYZ’ will have its size attribute updated. To update records in a table, as happens in any database, it is important to be sure about the script since once performed only in the return form backup can recover the lost information.

ibm-db2

DB2 has proven an excellent choice in the database and therefore is widely used in web projects, especially those using the PHP language, want to know why? Then visit our official page about DB2 in PHP projects and discover benefits of two technologies working together on your development project.

You might also like…

Do they pay for your system or code?

For all those who develop system and softwares every day at work: Have you ever wondered what makes...

What is Business Intelligence anyways?

Surely you have listened about the expression, “BI” or “Business Intelligence”, the questio...

Scriptcase & Web Services

This time I will explain how to work with web services inside the Scriptcase, directly with PHP and...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.