MySQL

/* Query 2. Write one DDL statement to add a new column AssignDate of date type in ProjAssignment table, which should allow no null values. Because there are already existing rows in the table which have no AssignDate data, your DDL statement should define a default value of current date in this column. When this statement is executed, it will therefore update the AssignDate of every existing row with a current date. */

E EEE dbo.ProjAssignment Columns o Pno (PK, char(3), not null) StulD (PK, FK, char(3), not null) E EEE dbo.Student Columns StulD (PK, char(3), not null) GPA (decimal(3,2), nul)