UPDATE statement is used to change, update or modify the existing records of a MariaDB table. It can be used with WHERE, OBDER BY and LIMIT clauses.

Syntax:

UPDATE table_name SET field=new_value, field2=new_value2,...

[WHERE ...]