MySQL: NOT NULL constraint

[@BroCodez]

CREATE TABLE products ( product_id INT, product_name varchar(25), price DECIMAL(4, 2) NOT NULL ); ALTER TABLE products MODIFY price DECIMAL(4, 2) NOT NULL; INSERT INTO products VALUES(104, "cookie", NULL);

[@derrickndi4576]

Thank you so much. Love all your lessons

[@solarwater3298]

3 Videos in 9 minutes E P I C

[@anasghassan360]

Love ur vids

[@Othjkdzv3552]

Thanks for the explanation. I was using google bard but it just gave me a complex break down which made me confused asf. Im very new to datamanagement.

[@jacobisrealpasi7156]

Nice, thanks man... needed this

[@محمودطلعت-ل9ه]

good job ,bro

[@jokeguy5946]

This guy is real Chad!

[@saimoomsikto9383]

can i use ADD CONSTRAINT instead of MODIFY ? IF NOT THEN WHY?

[@aadi._.9071]

well, modify will change the constrains to be the new constrain u add, but add constraint will add, not edit, i think this is the answer, not 100% sure tho

[@patrickmuthengi3499]

Hi bro, When you set a parameter not to accept NULL values and you put " " instead of a value or set of characters, it does not return an error. Please clarify this.

[@vivi694_]

because an empty string "" is considered a valid non-NULL value

[@iskier429]

yo man chill

[@BroCodez]

no

[@mohaymenul-islam]

✅ 10th October - 2024

[@OpinionOfX]

Ravish kumar official

[@fyrukmcoo100]

:((