MySQL /* Query 2. Write one DDL statement to add a new column AssignDate of date

Q: MySQL /* Query 2. Write one DDL statement to add a new column AssignDate of date

Please find my answer. Pelase rate my answer if it helped you!! ALTER ProjAssignment ADD AssignDatw Date DEFAUT getdate() NOT NULL; Default is keyword to set default date fetch by function getdate() i.e. current date

ID: 3736916 • Letter: M

Question

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)

Explanation / Answer

Please find my answer.

Pelase rate my answer if it helped you!!

ALTER ProjAssignment ADD AssignDatw Date DEFAUT getdate() NOT NULL;

Default is keyword to set default date fetch by function getdate() i.e. current date

Navigate

MySQL /* Query 2. Write one DDL statement to add a new column AssignDate of date

MySQL /* Query 3. Write one DDL statement to add a new table Project into exam1.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

MySQL /* Query 2. Write one DDL statement to add a new column AssignDate of date

Question

Explanation / Answer

Related Questions

Navigate