1.在表中增加一列uuid(原主键不动)
2.执行sql语句
update warehouseentry set uuid = UUID();
update warehouseentry set uuid = REPLACE(uuid,'-','');
3.将uuid设置为主键
4.取消原主键
1.在表中增加一列uuid(原主键不动)
2.执行sql语句
update warehouseentry set uuid = UUID();
update warehouseentry set uuid = REPLACE(uuid,'-','');
3.将uuid设置为主键
4.取消原主键