create table
============
CREATE TABLE product_order_info(
 product_no int NOT NULL AUTO_INCREMENT,
    product_name varchar(255) NOT NULL,
    product_type ENUM("Electronic","stationary","food","bevarage"),
    product_price float(10,2) NOT NULL,
    product_quantity SMALLINT NOT NULL,
    PRIMARY KEY(product_no)
);

insert
==========
INSERT INTO product_order_info VALUES
(1,"Mobile","Electronic",1700.45,5),
(2,"Laptop","Electronic",9700.75,6),
(3,"Butter","food",150.50,8),
(4,"Pen","stationary",10.25,15),
(5,"Mojo","bevarage",55.95,12);