Method for reducing database update quantity based on invalid independent update of annotation fields

The invention discloses a method for reducing database update quantity based on independent update invalidation of annotation fields, which is characterized by comprising the following steps of: S1, creating or modifying a database table through database management software, setting the newly created or modified database table as a variable T, obtaining the database table T and the like. According to the method, the attribute of'independent update invalidation 'is marked on the database field in advance during table establishment, so that whether the update statement submitted to the database is valid or not can be effectively judged, the invalid update statement is not executed by the database, the data volume of the binlog is reduced, the network flow of binlog copying between the master database and the slave database is reduced, and the efficiency of table establishment is improved. The updating amount of the database and the execution pressure of the database are effectively reduced, the service capacity