MySQL: NOT NULL constraint

Skip ad
120 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

brocode
Published
#MySQL #course #tutorial

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);
Category
Bro Code
Tags
MySQL tutorial, SQL tutorial, MySQL course
Be the first to comment