1.迁移直接使用navicat 12 ,数据传输,即可一键迁移;
2. 主键id自增设置
CREATE SEQUENCE t_entity_style_icon_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
Alter table t_entity_style_icon alter column id set default nextval('t_entity_style_icon_id_seq');
alter table t_block_def add primary key (id) ;
3.如果需要保留Mysql数据库,则id自增 start 需要设置为max(id)
do $$
declare maxid int;
begin
select COALESCE(max(id),1) from t_test into maxid;
execute 'alter SEQUENCE t_test_id_seq RESTART with '|| maxid;
end;
$$language plpgsql;
SELECT nextval('t_test_id_seq');