Question

Write MySQL commands to do the following:
1. Add the NOT NULL constraint to Salary column in Employee table.
Remove the NOT NULL constraint from Department column in Employee table.​

Answer 1

Explanation:

ajnsjsndjmsjdnskmakmqkdhndnenss

Answer 2

Try using the ALTER TABLE statement. ALTER TABLE table_name MODIFY ( column_name NOT NULL); In this case, the columnname must not contain any NULL value before applying the NOT NULL constraint.