Back to Blog
Online shopping project in java github5/22/2023 ![]() 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))
0 Comments
Read More
Leave a Reply. |