You can use the UPDATE statement in MariaDB to update multiple columns at once. Here’s the basic syntax:
```
UPDATE table_name
SET column1 = value1, column2 = value2, …, columnN = valueN
WHERE condition;
```
- `table_name`: Replace this with the name of the table where you want to update the data.
- `column1 = value1, column2 = value2, …, columnN = valueN`: Replace this with the columns you want to update and the corresponding values.
- `WHERE condition`: This is optional. You can put conditions here to specify which rows you want to update.
Here’s an example:
```
UPDATE employees
SET first_name = ‘John’, last_name = ‘Doe’, email = ‘johndoe@example.com‘
WHERE employee_id = 1;
```
In this example, it will update the `first_name`, `last_name`, and `email` of the row where `employee_id` equals `1` in the `employees` table.
