sql语句

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