Untitled

CREATE DATABASE MYDB;
USE MYDB;
CREATE TABLE PRODUCT(
     P_CODE INT primary key,
	 p_NAME VARCHAR(20) NOT NULL,
	 P_DESCRIPTION VARCHAR(100),
	 P_BRAND VARCHAR(50),
	 P_PRICE DECIMAL(5,2),
	 QUANTITY INT
);
INSERT INTO PRODUCT VALUES(100001,
'Bear Brand',
'Bear Brand Milk',
'Nestle',
890.85,
100
);

INSERT INTO PRODUCT VALUES(10002,
'Nescafe Classic'
'Instant coffe'
'Nescafe'
30.00
100
);
SELECT * FROM PRODUCT;