Migration from MySQL to PostgreSQL

1. How to migrate structure and data?

Esf_dbcv_pro_102019.exe is really a good thing. It's a versatile data structure and content conversion tool, and I didn't find it hard to convert it. Of course, it also claimed that the field type converted from SQLite was incorrect.

 

Ii. How to deal with the differences in syntax?

Limt in MySQL:

Select * From t_resource_base limit 100,10000;

The statement is rewritten to limit offset, which unifies the MySQL and PostgreSQL statements and facilitates future migration.

Select * From t_resource_base limit 10000 offset 100;

Note the two numbers after limit !!!