Monday, June 22, 2020

Answer for DEFAULT constraint

https://365datascience.com/dwqa-answer/answer-for-default-constraint/ -

Hi Ashakah!

Thanks for reaching out.

Please make sure you don’t skip any lecture or exercise while taking this course. We gradually modify the contents of our data tables and it is essential that you don’t skip any steps.

That said, it seems that currently you don’t have a field called last_name in your customers table. Please make sure you’ve completed the exercise of the UNIQUE Constraint lecture – https://365datascience.teachable.com/courses/360102/lectures/5518488 (which is the lecture preceding the one you are referring to). 
In other words, please make sure to have created and altered the customers table by executing the following code:


CREATE TABLE customers (
customer_id INT AUTO_INCREMENT,
first_name VARCHAR(255),
last_name VARCHAR(255),
email_address VARCHAR(255),
number_of_complaints INT,
PRIMARY KEY (customer_id)
);

ALTER TABLE customers
ADD COLUMN gender ENUM('M', 'F') AFTER last_name;

After you can confirm that you have done that, please retry executing the code you’ve posted in your question.

Hope this helps but please feel free to get back to us should you need further assistance. Thank you.

Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

No comments:

Post a Comment