The application discloses a
SQL statement template dynamic updating method and device, equipment and storage medium, relates to the field of databases, and comprises the following steps: constructing a to-be-matched template sequence of a to-be-processed
SQL statement; determining the longest common subsequence between each statement template sequence and the to-be-matched template sequence, determining a target statement template sequence from all statement template sequences based on all the longest common subsequences; if the sequence length of the longest common subsequence corresponding to the target statement template sequence is greater than or equal to a preset sequence length threshold, updating the target statement template sequence to the corresponding longest common subsequence in a dynamic statement template sequence
library; and if the sequence length of the longest common subsequence corresponding to the target statement template sequence is less than the preset sequence length threshold, adding the to-be-matched template sequence to the dynamic statement template sequence
library as a new statement template sequence. The application realizes updating of the dynamic statement template sequence
library of the
SQL statement.