Reference/Blocks

Databases blocks

10 blocks in the Databases category.

Database Lookup (Single)
db_lookup_single

Find a single row from a database matching your query. Returns the first matching row.

Database Lookup (Iterator)
Loop
db_lookup_iterator

Find multiple rows from a database and iterate over each one.

Database Create Row
db_create_row

Create a new row in a database with the specified values.

Database Duplicate Row
db_duplicate_row

Duplicate an existing row in a database by its ID.

Database Update Row
db_update_row

Update an existing row in a database with new values.

Clear Row Data
db_clear_row_data

Clear selected columns from a database row. Does nothing if the row does not exist.

Clear Matching Row Data
db_clear_matching_row_data

Find rows matching a query and clear selected columns from all of them.

Update Matching Rows
db_update_matching_rows

Find rows matching a query and update them all with the specified values.

Delete Matching Rows
db_delete_matching_rows

Delete rows matching a query and return how many were deleted.

Database Delete Row
db_delete_row

Delete a row from a database by its ID.