Select sum(user_qty) from tbl_order_detail,tbl_sub_cat,tbl_category,tbl_product where tbl_order_detail.p_id = tbl_product.p_id and tbl_product.sub_id = tbl_sub_cat.sub_id and tbl_sub_cat.c_id = tbl_category.c_id and tbl_category.c_id = 6

Select * from date_example where j_date between '' and '' Insert into date_example values(null,'') Insert into date_example values(null,CURDATE()) Update tbl_product set p_name = pname,p_desc = pdesc,p_price = pprice,p_qty = cur_qty,p_img = pimg,p_company = pcom,p_type = ptype where p_id = pid Select p_company,p_name,c_name,sub_name,p_qty,p_price,p_desc,p_img from tbl_product,tbl_category,tbl_sub_cat where tbl_product.sub_id = tbl_sub_cat.sub_id and tbl_sub_cat.c_id = tbl_category.c_id and tbl_product.p_id = 1 Ĭreate procedure st_change_product_info(pid int,pname varchar(30),pdesc varchar(30),pprice int,user_qty int,pimg varchar(30),pcom varchar(30),ptype varchar(20)) Update tbl_product set p_qty = cur_qty where p_id = pid ĭelete from tbl_order_detail where o_id = oid and p_id = pid Select p_qty into now_qty from tbl_product where p_id = pid Select user_qty into u_qty from tbl_order_detail where o_id = oid and p_id = pid Select p_id,p_name,p_price,p_desc,p_img,sub_name,c_name from tbl_product,tbl_sub_cat,tbl_category where tbl_product.sub_id = tbl_sub_cat.sub_id and tbl_sub_cat.c_id = tbl_category.c_id and p_id = 1 Ĭreate procedure st_cancle_order1(oid int,pid int) Update tbl_product set p_qty = new_total where p_id = pid Set new_total = total_products - user_qty

Select p_qty into total_products from tbl_product where p_id = pid Insert into tbl_order_detail values(null,o_id,pid,user_qty,total) Insert into tbl_product values(null,28,'Pen Cello Gripp','Easy to Write',40,10,'images/productImages/Cello Gripp.png','Cello','normal') įoreign key(o_id) references tbl_order(o_id),įoreign key(p_id) references tbl_product(p_id)) Ĭreate procedure user_buy_item1(o_id int,pid int,user_qty int,total int) Insert into tbl_product values(null,28,'Pen Cello Benz','Easy to Write',30,10,'images/productImages/Cello Benz Rectractable.jpg','Cello','normal') Insert into tbl_product values(null,1,'Nataraj Erasers','Best Product',30,10,'images/productImages/e3.jpg','Nataraj','special') Foreign key(l_id) references tbl_login(l_id)) įoreign key(c_id) references tbl_category(c_id)) įoreign key(sub_id) references tbl_sub_cat(sub_id))

Online shopping source code in java