How to Grant Update Permission on Table/s to a User in MariaDB

Below Syntax can be used to provide UPDATE permission on table/s in MariaDB.

Syntax:

On Single Table

MariaDB > GRANT UPDATE ON tableName to 'UserName'@'Host' 

On all the tables in a database

 MariaDB > GRANT UPDATE ON DatabaseName.* to 'UserName'@'Host' 

Example :
Let's say that if we have table "test" in Techbrothers Database and we would like to provide Update permission to user "Aamir" in MariaDB. we can use below statement

MariaDB > GRANT UPDATE ON Techbrothers.test to 'Aamir'@'localhost' 

 If we would like to provide UPDATE permission on all the tables in Techbrothers Database to user account Aamir in MariaDB, we can use below statement

MariaDB > GRANT UPDATE ON Techbrothers.* to 'Aamir'@'localhost'