Answer for Null value in a field specified to have no default?

https://365datascience.com/dwqa-answer/answer-for-null-value-in-a-field-specified-to-have-no-default/ -

Hi Mike!

Great to have you in the course and thanks for reaching out!

Please accept my apologies for the delayed response.

The problem you are facing is that you are trying to add a record in the departments_dup table without specifying data values for every field of the record you are inserting. Please remember that doing this is a must – in other words, when inserting a record, it must be clear to Workbench what value you intend to insert in every field from that record.

This means that we have to always specify values for every field while the only case in which we may skip doing that is if we had set a default value for a certain field that should appear in this field every time when we are adding a new record. 

You had done neither of the two, hence the error message you obtain. 

Therefore, please either add a DEFAULT constraint to the dept_name field, or just specify the value you wish to insert in this column while inserting a new record.

Hope this helps but please get back to us should you need further assistance. Thank you.
Best,
Martin

.
Best,
Martin

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