I need to create username and password,I don't think below works.
CREATE LOGIN sample
WITH PASSWORD='samplex'
thee database is about shopping app that lets you create account and shop with your cart. you also are needed to logged in, how can I do that? and how can I know who's logged in?
My other problem is how can I put many product into my cart?
INSERT INTO tbl_cart (items,itemcount)
VALUES (apple,5)
What if I bought banana,grapes,oranges together with apple. how can I retrieve what items are in the cart together with the apple.
What I have tried:
CREATE LOGIN sample
WITH PASSWORD='samplex'
INSERT INTO tbl_cart (items,itemcount)
VALUES (apple,5)