call create_order_infos(7,2,3);
delimiter
createprocedurecreateorderinfos(ininuseridint,ininproductidint,inincountint)beginselectinuserid′用户id′,inproductid′产品id′,incount′购买数量′;end
𝑐
𝑟
𝑒
𝑎
𝑡
𝑒
𝑝
𝑟
𝑜
𝑐
𝑒
𝑑
𝑢
𝑟
𝑒
𝑐
𝑟
𝑒
𝑎
𝑡
𝑒
𝑜
𝑟
𝑑
𝑒
𝑟
𝑖
𝑛
𝑓
𝑜
𝑠
(
𝑖
𝑛
𝑖
𝑛
𝑢
𝑠
𝑒
𝑟
𝑖
𝑑
𝑖
𝑛
𝑡
,
𝑖
𝑛
𝑖
𝑛
𝑝
𝑟
𝑜
𝑑
𝑢
𝑐
𝑡
𝑖
𝑑
𝑖
𝑛
𝑡
,
𝑖
𝑛
𝑖
𝑛
𝑐
𝑜
𝑢
𝑛
𝑡
𝑖
𝑛
𝑡
)
𝑏
𝑒
𝑔
𝑖
𝑛
𝑠
𝑒
𝑙
𝑒
𝑐
𝑡
𝑖
𝑛
𝑢
𝑠
𝑒
𝑟
𝑖
𝑑
′
用
户
𝑖
𝑑
′
,
𝑖
𝑛
𝑝
𝑟
𝑜
𝑑
𝑢
𝑐
𝑡
𝑖
𝑑
′
产
品
𝑖
𝑑
′
,
𝑖
𝑛
𝑐
𝑜
𝑢
𝑛
𝑡
′
购
买
数
量
′
;
𝑒
𝑛
𝑑
delimiter;
————————————————
版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
原文链接:https://blog.csdn.net/hanhanhan77799_/article/details/139835415