1. 使用 insert into *** select * from ..方式
参考:https://www.cnblogs.com/duanxz/p/5208336.html
INSERT INTO wms.`warehouse_inventory_report`
SELECT UUID_SHORT(),`store_id`,`customer_id`,`sku_id`, 1 AS category_id,
start_num,
SUM(IF (t.type=1, t.change_count_total,0) ) AS `add_num`,
SUM(IF (t.type=0, t.change_count_total,0) ) AS `sub_num`,
`create_time`, NOW()
FROM
(SELECT * FROM warehouse_inventory_log
ORDER BY create_time) t
GROUP BY store_id, sku_id,customer_id;
2. 生成主键
SELECT UUID_SHORT(),REPLACE(UUID(),'-','') form dual;
https://blog.csdn.net/l1028386804/article/details/51140577
3. 修改数据库表:增加一个字段(ADD)
ALTER TABLE wms.basket ADD COLUMN order_no varchar(50) DEFAULT NULL COMMENT '订单号';
4. 修改数据库表:修改一个字段类型(modify )
alter table wms.basket modify column qty decimal(12,2) DEFAULT NULL comment '数量';
5.修改数据库表:修改一个字段(CHANGE ,把一个字段修改为 一个新的字段)
ALTER TABLE wms.basket CHANGE completed_qty total_qty decimal(12,2) DEFAULT NULL comment '订单商品总数';