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…

PROCESAMIENTO AJAX EN SCRIPTCASE

Ajax en los formularios de Scriptcase puede usarse para recargar un campo de tipo de select basado e...

IMPORTAR IMAGENES DE LA BASE DE DATOS Y UTILIZAR CLASES DE BOOSTRAP

Como muchas personas ya saben, Bootstrap es una biblioteca de front-end libre y de código abierto p...

TENDENCIAS DE DESARROLLO WEB PARA 2017

Usted verá en este post tendencias para 2017 en Diseño Web, en el medio digital y en el desarrollo...

Comment this post

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.