摘要: -- 收支明细(订单类型) update tb_cloud_income_expenditure a LEFT JOIN tb_cloud_order_app b on a.order_id = b.order_id set a.order_type = b.order_type WHERE a.o 阅读全文
posted @ 2022-01-12 17:12 黄河大道东 阅读(29) 评论(0) 推荐(0) 编辑
摘要: DROP PROCEDURE IF EXISTS test_select; DELIMITER ;; CREATE PROCEDURE test_select () BEGIN DECLARE i int; set i=1; WHILE i<5 DO SELECT id FROM sys_user 阅读全文
posted @ 2022-01-12 15:44 黄河大道东 阅读(17) 评论(0) 推荐(0) 编辑