SELECT
id,
transfer_no,
supply_warehouse_id,
receive_warehouse_id,
submitter_id,
submit_time,
STATUS,
remark,
shop_id
FROM
warehouse_transfer
WHERE
shop_id = 1
AND submit_time BETWEEN ‘2020-07-23 00:00:00’ AND ‘2020-07-23 23:59:59’
ORDER BY
submit_time DESC
LIMIT 0,
15
SELECT * FROM city_product WHERE NAME LIKE CONCAT(’%’,‘长江’,’%’);
ALTER TABLE merchant_balance_refund DROP COLUMN refund_method
ALTER TABLE refund_order drop column refund_method
ALTER TABLE refund_order
ADD COLUMN refund_method varchar(50) COMMENT ‘退款方式’ AFTER pay_method;
ALTER TABLE merchant_balance_refund
ADD COLUMN refund_method varchar(50) COMMENT ‘退款方式’ AFTER amount;
UPDATE d SET
NAME = CASE id
WHEN 1 THEN ‘刘德华’
WHEN 2 THEN ‘张学友’
WHEN 3 THEN ‘周星驰’
END
WHERE id IN (1,2,3)
UPDATE d SET NAME = ‘快乐’ WHERE id = 1
ALTER TABLE dongpinyun_uat
.branch_order_detail
ADD INDEX idx_receiver_shop_id
(receiver_shop_id
) USING BTREE;
// 复制表结构
CREATE TABLE IF NOT EXISTS merchant_backup1 (LIKE merchant_group);
//复制表数据
INSERT INTO merchant_backup1 SELECT * FROM merchant_group