MySQL: NOT NULL constraint

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);

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.

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

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.

good job ,bro

Ravish kumar official

yo man chill

This guy is real Chad!

3 Videos in 9 minutes E P I C

Thank you so much. Love all your lessons

Nice, thanks man... needed this

:((

Love ur vids