Web Scrapers Generator BrowserExt

dbupdate

Updates records in a database table.

dbupdate(connection, table, attrs, whereattrs)
    

Parameters:

connection Connection ID established by dbconnect.
table Table name.
attrs Dictionary of attributes that will be updated in a database table. The key element of the dictionary corresponds to the name of a column in a table.
whereattrs Records to update will be selected based on the values ​​of this dictionary of attributes. The key element of the dictionary corresponds to the name of a column in a table.

This function can not be executed in the "Editor".

Example 1. Lets suppose that there is products table in the test database, containing id, t, d and p columns. Lets update the record with id=10 and set p=30.