gouwuche.sql

来自「完成一个网上书店系统」· SQL 代码 · 共 9 行

insert into ShopCart
( BookID,BookName,BookMarketPrice,BookPrice,ShopDate,IsCanel,UserID)
select BookID,BookName,BookMarketPrice,BookPrice ,GETDATE(),0,UserID 
from Books,Users where UserID=1 and BookID= 3


update ShopCart set BookCount=BookCount+1,MoneyCount=BookPrice*(BookCount+1),IsCanel='0' where UserID=1 and BookID=1

select * from ShopCart where  UserID=1 and BookID=1