w3resource

PostgreSQL Update Table: Change the value of a column with user defined text


1. Write a SQL statement to change the email column of the employees table with 'not available' for all employees.

Sample table: employees


Sample Solution:

Code:

UPDATE employees SET email='not available';

Output:

See the result. Only two rows have been displayed.

postgres=# SELECT * FROM employees LIMIT 2;
 employee_id | first_name | last_name |     email     | phone_number | hire_date  | job_id  |  salary  | commission_pct | manager_id | department_id
-------------+------------+-----------+---------------+--------------+------------+---------+----------+----------------+------------+---------------
         100 | Steven     | King      | not available | 515.123.4567 | 1987-06-17 | AD_PRES | 24000.00 |           0.00 |          0 |            90
         101 | Neena      | Kochhar   | not available | 515.123.4568 | 1987-06-18 | AD_VP   | 17000.00 |           0.00 |        100 |            90

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming