MariaDB SET Keyword
The MariaDB SET keyword is used with MariaDB UPDATE statement and it is used to specify which columns and values that should be updated in a table. A MariaDB WHERE clause can be used with the UPDATE statement to update the selected rows, otherwise all the rows will be assigned the updated value.
Syntax
The syntax for using SET keyword in MariaDB is given below:
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition(s);
Example:
Consider a database containing a table called Employee with the following records:
EmpID | Name | City | Age | Salary |
---|---|---|---|---|
1 | John | London | 25 | 3000 |
2 | Marry | New York | 24 | 2750 |
3 | Jo | Paris | 27 | 2800 |
4 | Kim | Amsterdam | 30 | 3100 |
5 | Ramesh | New Delhi | 28 | 3000 |
6 | Huang | Beijing | 28 | 2800 |
-
To update the City and Salary of an employee whose EmpID is 5, the statement will be:
UPDATE Employee SET City = 'Mumbai', Salary = 2900 WHERE EmpID = 5; --See the result SELECT * FROM Employee
Now the Employee table will contain following records:
EmpID Name City Age Salary 1 John London 25 3000 2 Marry New York 24 2750 3 Jo Paris 27 2800 4 Kim Amsterdam 30 3100 5 Ramesh Mumbai 28 2900 6 Huang Beijing 28 2800
❮ MariaDB Keywords