The difference between insert and insertseletive,updatebyprimarykey,updatebyprimarykeyselective method in MyBatis automatic generation of Mapper

For insert:

Insert a piece of data
Supports Oracle sequence, UUID, mysql-like indentity automatic growth (automatic writeback)
Use a sequence, UUID, and automatically grow when the parameter value is empty, using the incoming parameter value first
But be aware that if the database field has Default,default, it won't work.

For insertselective:

Inserts a piece of data, inserts a field that is not NULL, and does not affect fields with default values
Supports Oracle sequence, UUID, mysql-like indentity automatic growth (automatic writeback)
Use a sequence, UUID, and automatically grow when the parameter value is empty, using the incoming parameter value first
Insertselective does not ignore default, which is an empty field default AutoFill

For Updatebyprimarykey:

Update all the fields you injected (do not judge whether it is null)

For updatebyprimarykeyselective:

The field is judged and updated (the update is ignored if null)

By distinguishing these, it is easy to select a service layer invocation based on the business.
For more information, you can view the Objectnamemapper.xml source code generated by generator.